topic Re: Date Issue in QlikView

Date Issue

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

Hi Team,

My Date format is 17-JAN-14 i have tried to convert it into max date/Date but unable to do the same

I wanted to calculate YTD MTD and QTD so i need the variables for the same.But my date is no geting converted it is showing '-'

Please help for the same.

Regards,

sunny_talwar — Tue, 23 Aug 2016 12:36:34 GMT

May be this:

=Date(Date#([CREATED],'DD-MMM-YY'),'DD/MM/YYYY')

sunny_talwar — Tue, 23 Aug 2016 12:37:27 GMT

=Date(Date#(Capitalize([CREATED]),'DD-MMM-YY'),'DD/MM/YYYY')

Karim_Khan — Tue, 23 Aug 2016 12:38:51 GMT

no bro still showing -

Chanty4u — Tue, 23 Aug 2016 12:39:05 GMT

try this

in script

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

maxgro — Tue, 23 Aug 2016 12:39:06 GMT

if you have JAN, you need MMM

=Date(Date#([CREATED],'DD-MMM-YY'),'DD/MM/YYYY')

sunny_talwar — Tue, 23 Aug 2016 12:41:04 GMT

How about this?

=Date(Date#(Capitalize([CREATED]),'DD-MMM-YY'),'DD/MM/YYYY')

Anonymous — Tue, 23 Aug 2016 12:49:38 GMT

In the editor Please change as below ?

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oc