Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor

Re: Date format.

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

or

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

7 Replies
manas_bn
Contributor

Re: Date format.

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

or

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

Re: Date format.

HI

Try like this

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

or

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

Re: Date format.

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

Re: Date format.

THANK YOU

Not applicable

Re: Date format.

THANK YOU

Not applicable

Re: Date format.

ONE MORE QUESTION,

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

Re: Date format.

Hi

Try like this

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

Community Browser