how to change date format

[anjali0108]

Hi, The data i have has the field 'Time period ' in the following format :- Tue, Dec 31 10:15 PM .

How can i change its format to create the master calendar ..

Any suggestions .

[Miguel_Angel_Baeyens · Accepted solution]

Hi Anjali,

I'm missing the year there, but you can try the following

Date(Today(), 'WWW, MMM DD hh:mm TT')

And should see the returning value with the same format as you mention.

Miguel

[#3]

Hi,

You can try this script.

Date(Date#(Time period, 'WWW, MMM DD hh:mm TT'),'MM-DD hh:mm')    as period

[#4]

Hiii

try this expressions

1) SET DateFormat='DD-MM-YYYY';

2) date(today(),'MM-DD-YYYY') = 01-04-2015