topic Character to Date in QlikView

Character to Date

VishalWaghole — Mon, 18 Feb 2013 10:32:58 GMT

Dear friends,

Its Urgent for me, if anybody know then please help us.

How can i convert Character formate into Date Formate in QlikView.

Thanks and Regards,

Vishal

Re: Character to Date

swuehl — Mon, 18 Feb 2013 10:36:52 GMT

Use the date#() function:

Date#(DATEASCHAR,'YYYY-MM-DD') as DateAsQVDate,

please check the QV date and time format codes to create an appropriate format code string.

Stefan

Re: Character to Date

Anonymous — Mon, 18 Feb 2013 10:37:45 GMT

Hi Vishal,

You can use the Date#() format to tell QlikView how to interpret a string as a date value (See the F1 help for examples), and then use Date() to format this into the date format you want.

Re: Character to Date

its_anandrjs — Mon, 18 Feb 2013 10:40:45 GMT

Hi,

Use Date# function like

Date#(Datefield , 'DD/MM/YYYY')

But first check what is your date format in DateFormat variable according to that put date format

SET DateFormat='DD/MM/YYYY';

Regards,

Anand

Re: Character to Date

martin59 — Mon, 18 Feb 2013 10:41:39 GMT

Hi Vishal,

You have to use date#() function.

For example, if your date field is like this : '20130218' (in text format).

Use the function to convert to date format like this :

Date#(FieldName, 'YYYYMMDD') as FieldName // the 2nd parameter is the input format

Your field is now numeric, if you want to modify the output format, you have to do this :

Date(Date#(FieldName, 'YYYYMMDD'),'DD/MM/YYYY') as FieldName // the output format will be DD/MM/YYYY

Hope that helps you

Martin Favier

Re: Character to Date

martin59 — Mon, 18 Feb 2013 10:41:54 GMT

Hi Vishal,

You have to use date#() function.

For example, if your date field is like this : '20130218' (in text format).

Use the function to convert to date format like this :

Date#(FieldName, 'YYYYMMDD') as FieldName // the 2nd parameter is the input format

Your field is now numeric, if you want to modify the output format, you have to do this :

Date(Date#(FieldName, 'YYYYMMDD'),'DD/MM/YYYY') as FieldName // the output format will be DD/MM/YYYY

Hope that helps you

Martin Favier

Re: Character to Date

Sokkorn — Mon, 18 Feb 2013 10:46:53 GMT

Hi Vishal,

Test this one : Date(Date#('18-02-2013','dd-MM-yyyy'),'dd/MM/yyyy')

Try to convert with your field : Date(Date#(MyDate,'dd-MM-yyyy'),'dd/MM/yyyy')

Regards,

Sokkorn