topic Date Time Stamp in QlikView

Date Time Stamp

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

I have a date/time stamp that has been given to me in this format: 2017-02-28T00:00:00+00:00

What do I need to put in the script to get rid of the time part?

So I want it to just show DD/MMM/YYYY..

Re: Date Time Stamp

Frank_Hartmann — Mon, 03 Apr 2017 14:25:13 GMT

Try that:

date(floor(Timestamp(now()))) as Timestamp

hope this helps

Re: Date Time Stamp

Anil_Babu_Samineni — Mon, 03 Apr 2017 14:27:25 GMT

From given data you are expecting this? 28/02/2017 0:00:00.

You can use this =Timestamp('2017-02-28T00:00:00+00:00')

Re: Date Time Stamp

khaycock — Mon, 03 Apr 2017 14:29:37 GMT

I tried this in the script..

timestamp(DueDate),

and it returned a null value instead

Re: Date Time Stamp

Anil_Babu_Samineni — Mon, 03 Apr 2017 14:32:30 GMT

I tried this and it return image

LOAD Timestamp(DueDate) as DueDate Inline [

DueDate

2017-02-28T00:00:00+00:00

];

Re: Date Time Stamp

annafuksa1 — Mon, 03 Apr 2017 14:41:30 GMT

try to use

date:

LOAD date(Date#(left(DueDate,10) ,'YYYY-MM-dd'))as DueDate

Inline [

DueDate

2017-02-28T00:00:00+00:00

];

Re: Date Time Stamp

yoganantha321 — Mon, 03 Apr 2017 14:43:51 GMT

Hi Karthryn,

I have tried with the following

date(DateEntering,'DD/MMM/YYYY') as DateEntering and got output as the below image

I think this is useful for you

Re: Date Time Stamp

khaycock — Mon, 03 Apr 2017 14:48:32 GMT

It giving me a blank response

Re: Date Time Stamp

Frank_Hartmann — Mon, 03 Apr 2017 14:55:10 GMT

date(Date#(left(DueDate,10) ,'YYYY-MM-DD'),'DD/MMM/YYYY')

Re: Date Time Stamp

CarlosAMonroy — Mon, 03 Apr 2017 14:55:26 GMT

Hi Kathryn,

Try this:

date(left(DateField,10),'DD/MMM/YYYY')

thanks,

Carlos M

Re: Date Time Stamp

annafuksa1 — Mon, 03 Apr 2017 14:55:34 GMT

you need to use this

LOAD date(Date#(left(DueDate,10) ,'YYYY-MM-dd'))as DueDate

Re: Date Time Stamp

annafuksa1 — Mon, 03 Apr 2017 14:56:44 GMT

or you can use this

LOAD date(Date#(left(DueDate,10) ,'YYYY-MM-dd'),'DD/MMM/YYYY') as DueDate