how to convert date format (20-Oct-2012) into mm/dd/yyyy format ?

[bell_byloli]

hello,

how to convert a field containing date format (20-Oct-2012) into MM/DD/YYYY format ?

Regards

[PrashantSangle · Accepted solution]

Hi,

Try this,

Date(Date#(fieldname,'DD-MMM-YYYY'),'MM/DD/YYYY')

Regards,

[senpradip007]

try thid

Date(Date#('20-Oct-2012', 'DD-MMM-YYYY'), 'mm/dd/yyyy')

[MK_QSL]

=Date(Date#('20-OCT-2012','DD-MMM-YYYY'),'MM/DD/YYYY')

or

=Date(Date#([Your Date Field],'DD-MMM-YYYY'),'MM/DD/YYYY')

[#5]

Hi,

Try this

=

Date(Date#('20-oct-2011','DD-MMM-YYYY'),'MM/DD/YYYY')

Regards

Kumar

[its_anandrjs]

Hi,

First you had to convert this date into number Date#('20-Oct-2012','DD-MMM-YYYY') and current date format then

convert it into your any date format like

Date(Date#('20-Oct-2012','DD-MMM-YYYY'),'MM/DD/YYYY')

Thanks & Regards

[CELAMBARASAN]

Just to make sure, it that field already is in date then, simply use

Date(fieldname, 'MM/DD/YYYY')

Since it is already a date, not need date format conversion here.

[#8]

If you check the field date propriety, you can change the format number!

Look the attached!