Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
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
Hi,
You can try this script.
Date(Date#(Time period, 'WWW, MMM DD hh:mm TT'),'MM-DD hh:mm') as period
Hiii
try this expressions
1) SET DateFormat='DD-MM-YYYY';
2) date(today(),'MM-DD-YYYY') = 01-04-2015