Dtae format

[Krish2459_58]

Hi ,

How to change the below date to standard date format as dd/mm/yyyy

2024-12-31T08:00:00Z

Thanks,

K

[Chanty4u]

Try this 

        Date#(Left(YourDateField, 10), 'YYYY-MM-DD') as YourDateField

[Vegar · Accepted solution]

I would try something like this

dayname(timestamp#(DateField,'YYYY-MM-DDThh:mm:ssZ'))