Friday, 22 December 2017

vlocity - omniscript formula to get firstday of current month


Add the below in the formula box to get first day of current month

DATE(
IF(
OR(%Month%==null,%Year%==null),
 MONTH(TODAY())+'/02/'+YEAR(TODAY()),
(%Month%+'/'+'02'+'/'+%Year%)
)
)


No comments:

Post a Comment