Getting Day of Week (DOW) from a YYYYMMDD variable date

Questions & Suggestions
1

When using ICUDateTimeFor and time function, you do not need the %Variable% references, you can explicitly use the variable name. Also, to avoid time zone issues, you can either use "12" noon which will work for most timezones or use the GMTOFFSET() function

%ICUDateTimeFor%TIME(year,month,day,12,0,0)%e%
or
%ICUDateTimeFor%TIME(2022,07,05)-GMTOFFSET()%e%

kbmdateexample
kbmdateexample1178×1100 125 KB

Thanks to Peter for providing the tip.

1 Like