Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert such example using script to get 'MM/DD/YYYY' ? Simple Date#() doesn't work. Thanks in advance for any tip.
1/8/2021 9:08 AM |
Your string is not a date it is a timestamp. That's why date#() won't work, but timestamp#() should .
Try this
DayName(timestamp#(YourString, 'M/D/YYYY h:mm TT'))