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

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


Thanks to Peter for providing the tip.

1 Like