Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format.


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.

1 Solution

Accepted Solutions
manas_bn
Creator
Creator

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

or

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

View solution in original post

7 Replies
manas_bn
Creator
Creator

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')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

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')

Not applicable
Author

THANK YOU

Not applicable
Author

THANK YOU

Not applicable
Author

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')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.