topic Date conversion in QlikView

Date conversion

AH — Fri, 11 Mar 2016 00:28:07 GMT

Hi,

I had a date field with values like this: '01-02-2016' and i want to make the value a format like this: '41640'.

How to convert the date value to a number like this?

Any help!

Thanks,

ahmed100

Re: Date conversion

MarcoWedel — Fri, 11 Mar 2016 00:56:33 GMT

Num(Date#( '01-02-2016' ,'MM-DD-YYYY'))

regards

Marco

Re: Date conversion

AH — Fri, 11 Mar 2016 01:05:46 GMT

Thanks Marco!

Regards,

Ahmed100

Re: Date conversion

jagan — Fri, 11 Mar 2016 01:07:36 GMT

HI,

Try like this

LOAD

Num(Date#( DateFieldName ,'MM-DD-YYYY')) AS DateFieldName_Number

FROM DAtaSource;

If above not working then try this

LOAD

Num(DateFieldName) AS DateFieldName_Number

FROM DAtaSource;

Hope this helps you.

Regards,

Jagan.

Re: Date conversion

AH — Fri, 11 Mar 2016 02:09:41 GMT

Hi Jagan,

I also have two other conversion to take care:

1. Convert Date field format '01-02-2016' to '01/02/2016' format and

2. Convert Date field format '41640' to '01/02/2016' format

Thanks in advance.

Regards,

ahmed100

Re: Date conversion

jagan — Fri, 11 Mar 2016 02:45:30 GMT

HI,

Try like this using Alt() if both dates are in single column

LOAD

Date(Alt(Date#(FieldName, 'MM-DD-YYYY'), FieldName) AS NewField

FROM DataSource;

Regards,

Jagan.

Re: Date conversion

AH — Fri, 11 Mar 2016 03:03:17 GMT

Hi Jagan,

Thanks for your reply. But They are different fields.

Regards,

ahmed100

Re: Date conversion

jagan — Fri, 11 Mar 2016 03:21:46 GMT

HI,

Then try like this separately

Date(Date#(FieldName1, 'MM-DD-YYYY'))

Date(FieldName2)

Regards,

Jagan.

Re: Date conversion

AH — Sun, 13 Mar 2016 02:50:04 GMT

Hi Jagan,

Could you show me, how To convert date format '41640' to date format 'YYYY-MM-DD' ?

Thanks,

ahmed100

Re: Date conversion

jagan — Sun, 13 Mar 2016 03:48:25 GMT

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

Regards,

Jagan.

Re: Date conversion

AH — Sun, 13 Mar 2016 19:24:38 GMT

Thanks a lot Jagan!

Regards,

ahmed100

Re: Date conversion

bhavvibudagam — Mon, 28 Mar 2016 09:10:15 GMT

Hi jagan,

Can you please tell me how to represent December 21, 2016 20:18 in Date format like MMMM DD,YYYY hh:mm or anything.My required format is MM/DD/YY

Re: Date conversion

jagan — Tue, 05 Apr 2016 04:02:09 GMT

Hi,

Try this

MMMM DD,YYYY hh:mm

Regards,

Jagan.