Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to change the below date to standard date format as dd/mm/yyyy
2024-12-31T08:00:00Z
Thanks,
K
I would try something like this
dayname(timestamp#(DateField,'YYYY-MM-DDThh:mm:ssZ'))
Try this
Date#(Left(YourDateField, 10), 'YYYY-MM-DD') as YourDateField
I would try something like this
dayname(timestamp#(DateField,'YYYY-MM-DDThh:mm:ssZ'))