Date format in script, removing unwanted characters/letters

[Maciej29]

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

[Vegar]

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'))