topic Re: date format in QlikView

date format

master_student — Tue, 21 Feb 2017 13:37:10 GMT

Hello Guys,

I hope all is well.

I have a date field with that format

valid_from

12/08/2015 00:00

I did the expression bellow in the script to extract only the date DD/MM/YYYY

Date(Date#(valid_from, 'DD/MM/YYYY'), 'DD/MM/YYYY') AS detection_date but it returns nothing

do you have any idea please?

Thanks

MK_QSL — Tue, 21 Feb 2017 13:40:32 GMT

Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm'))) as detection_date

Date(Floor(TimeStamp#(valid_from, DD/MM/YYYY hh:mm')),'DD/MM/YYYY') as detection_date

Tue, 21 Feb 2017 13:46:49 GMT

Hey Wiem,

In your original string, the date and time is formatted like 'DD/MM/YYYY hh:mm'

You need to make sure that in the Date#(valid_from, 'DD/MM/YYYY') function the date itself is formatted as how it is

in the original string so:

Date(Date#(valid_from, 'DD/MM/YYYY hh:mm'), 'DD/MM/YYYY') AS detection_date

Good luck!

Ivo

master_student — Tue, 21 Feb 2017 15:13:55 GMT

Thanks but it didn't work.

vishsaggi — Tue, 21 Feb 2017 15:52:09 GMT

Can you share your script or a sample app to look into?

qlikview979 — Tue, 21 Feb 2017 17:11:29 GMT

Hi,

I hope this is helpful to you

Floor(valid_from) as valid_from

Regards,

Mahesh