topic Re: Date issue in QlikView

Date issue

Wed, 25 Nov 2020 16:16:04 GMT

my date and time should be in the format of dd.mm.yyyy 00:00:00 , but when I pull the date from QVD in to QV datamodel file,

I am getting the below image

COMPLETEDUTC is the date with time.

I need to calculate Max and min of Dates.

So, I want to change this number to dd.mm.yyyy 00:00:00, can some one help.

Re: Date issue

Anil_Babu_Samineni — Tue, 26 Sep 2017 14:49:53 GMT

Use this

TimeStamp(COMPLETEDUTC) as COMPLETEDUTC

Re: Date issue

fvelascog72 — Tue, 26 Sep 2017 14:50:06 GMT

Hi,

Try with:

http://help.qlik.com/es-ES/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Timestamp.htm

Saludos

Re: Date issue

sunny_talwar — Tue, 26 Sep 2017 14:50:31 GMT

Date and Timestamps have an underlying numerical value... if you just add TimeStamp() function around your date field, it will get the format you would want. But to calculated min and max, you don't really need formatting function as you can find the min and max of the underlying numerical value which should be the same things as finding the min and max of formatted timestamp

Re: Date issue

Tue, 26 Sep 2017 15:18:42 GMT

Hi Sunny,

Thank you for the reply,

When I used Time stamp function and see, I got the dates of 2016 also, But I want to load from date 01Jan2017 00:00:00,

Re: Date issue

Tue, 26 Sep 2017 15:20:37 GMT

Thank you Anil. I got the dates, but not in DD.MM.YYYY format, I got in YY-MM-DD 00:00:00. I think I can manage

Re: Date issue

sunny_talwar — Tue, 26 Sep 2017 15:20:48 GMT

Where clause

LOAD ....

FROM ...

Where Date >= MakeDate(2017);

Re: Date issue

Anil_Babu_Samineni — Tue, 26 Sep 2017 15:22:43 GMT

You can use like below

TimeStamp(COMPLETEDUTC,'DD.MM.YYYY hh:mm:ss TT') as COMPLETEDUTC

Re: Date issue

Tue, 26 Sep 2017 15:32:25 GMT

Hi Sunny,

Awesome!! Thank you very much

Re: Date issue

its_anandrjs — Tue, 26 Sep 2017 17:37:26 GMT

It seems you need to load the year data that is 2017 so why not you make it dynamic so you no need to hard code it

Ex:-

Load * From source

Where Date >= MakeDate( Year(Today()) );