topic Re: Date Format in QlikView

Date Format

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have Start Date field like below:

Start Date
12-JAN-16
01-FEB-88
06-MAR-98
03-APR-17
02-FEB-01

I am converting Start Date to Date(Start Date,'DD/MM/YYYY').

After converting Start Date i am getting below wrong values:

Start Dtae
12-01-2016
01-02-2088
06-03-2098
03-04-2017
02-02-0001

I want start date like below:

12-01-2016

01-02-1988

06-03-1998

03-04-2017

02-02-2001

Thanks

Gireesh

Re: Date Format

jonathandienst — Thu, 25 May 2017 08:22:40 GMT

Use Date(Date#([Start Date], 'DD-MMM-YY'), 'DD/MM/YYYY')

This returns the correct year for me.

Re: Date Format

gireesh1216 — Thu, 25 May 2017 09:58:04 GMT

Hi Jonathan,

Above expression not working

Re: Date Format

Sergey_Shuklin — Thu, 25 May 2017 10:03:53 GMT

Hi, Gireesh!

If you use it within the script - check your date format on the top of the script. May be date format from there have a conflict with your expression (it's have a little chance to be true, but still).

Re: Date Format

ahaahaaha — Thu, 25 May 2017 10:15:09 GMT

Hi,

May be like this

Date(Date#([Start Date], 'DD-MMM-YY'), 'DD-MM-YYYY')

Andrey

Re: Date Format

amit_saini — Thu, 25 May 2017 10:42:22 GMT

Hi,

See the attachment!

Date(Date#([Start Date], 'DD-MMM-YY'), 'DD/MM/YYYY') as Date

Thanks,

Re: Date Format

gireesh1216 — Thu, 25 May 2017 12:18:06 GMT

SORRY Jonathan,

It's working fine.

Re: Date Format

jonathandienst — Fri, 26 May 2017 06:04:55 GMT

No problem. Glad to be able to help.