how do you substring only the year or month from current date
USER>Write $Piece($ZDate($Horolog,9)," ")JanuaryUSER>Write $Piece($ZDate($Horolog,3),"-")2018
You can use DATEPART function:
w $SYSTEM.SQL.DATEPART("year", $h)
w $SYSTEM.SQL.DATEPART("month", $h)
The advantage of this approach is more readable code.
To leave a comment or answer to post please log in
Please log in