Date format.

[#1]

I have a field called TIME_ID with date in the format 20130623.How can I change this to the format 06-23-2013 ?

Thanks in advance.

[manas_bn · Accepted solution]

Date(Date#( '20130623', 'YYYYMMDD' ) ,'MM-DD-YYYY')

or

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

[MayilVahanan]

HI

Try like this

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

or

Date(Date(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

[CELAMBARASAN]

Hi,

Use Date# function if the field is not in date format.

Date(Date#(TIME_ID, 'YYYYMMDD'), 'MM-DD-YYYY')

if it is already in date format then use

Date(TIME_ID, 'MM-DD-YYYY')

[#5]

THANK YOU

[#6]

THANK YOU

[#7]

ONE MORE QUESTION,

How can I convert  this into the format Jan-13,feb-13,mar-13 and so on?

[MayilVahanan]

Hi

Try like this

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MMM-YY')