Date formatting

[#1]

Hi All,

I am having trouble with the formatting of date.

The source is currently in this format

yyyy/mm/dd - session number, e.g, 2010/06/30 - 406

I am trying to create a master calendar with this date field.

I removed the session number from the field using subfield, and I am left with the date.

I want the date to be DD/MM/YY, so i use the Date function;

Date(SUBFIELD(SessionDate,'-',1),'DD/MM/YYYY') AS NewDate but while the session number is successfully removed, the format remains unchanged.

Anyone can help?

[nagaiank · Accepted solution]

Try the following:

Date(Date#(Trim(SubField(SessionDate,'-')),'YYYY/MM/DD'),'DD/MM/YYYY') as NewDate

[#3]

I tried that as soon as I finished writing this post and yes, it works, many thanks