Help me with converting date format.

[#1]

I have a date field called Monthrecorded in  myy  format.How can I covert this into mmddyyy format.

Thanks in advance.

[Siva_Sankar]

use

=(monthfieldname,'MM-DD-YYYY')

Regards.

Siva

[#3]

I am getting the syntax error.can you tell me why?

Thanks.

[Anonymous]

Use the function

date(Monthrecorded ,'MMDDYYY')

[jagan]

Hi,

Try like this

=date(Date#('114', 'MYY'), 'MMDDYYYY' )

Regards,

Jagan.

[#6]

Hello,

You can use below expression:

=Date(Date#(Monthrecorded,'MYY'),'MMDDYYYY')

Thanks,

Angad

[dmohanty · Accepted solution]

Try this:

=Date(Date#(Monthrecorded,'MYY'),'MMDDYYYY')

[#8]

Hi Aptha,

Please send me the sample data will try to give solution. May be your field is having the string data. that is what its showing the syntax error.