substring only the year or month from current date

Question

Question

Permo Jacobs · Jan 17, 2018

how do you substring only the year or month from current date

Discussion (2)0

Log in or sign up to continue

Aman Rana · Jan 17, 2018

USER>Write $Piece($ZDate($Horolog,9)," ")
January
USER>Write $Piece($ZDate($Horolog,3),"-")
2018

0 0

score 1 · Answer 1 · 2018-01-17T09:03:30-05:00

You can use DATEPART function:

w $SYSTEM.SQL.DATEPART("year", $h)
>2018
w $SYSTEM.SQL.DATEPART("month", $h)
>1

The advantage of this approach is more readable code.