Date Format

[aveeeeeee7en]

Hi All

I have date field in this Format:    07-08 8-2013 12:44:11

I need date field in this Format:    07-08-2013 12:44:11

Only Month is in different Format.

I am getting desired result by using this:

SubField(SystemClosedDateTime,'-',1)&'-'&Left(SubField(SystemClosedDateTime,'-',2),2)&'-'&Left(SubField(SystemClosedDateTime,'-',3),4)

Is there any other way which will only change the month Format (08 😎 and rest Date and Year work as it is.

Regards

Aviral Nag

[PrashantSangle]

Hi,

Please find attached file for your reference.

Regards,

[tresesco]

Your data is properly formatted, it is just been shown like that. Goto number tab, select timestamp as format.

[aveeeeeee7en]

Thank You Everyone.