topic Re: Format date in script in QlikView

Format date in script

evansabres — Tue, 30 Oct 2018 19:41:09 GMT

I have a field called [Event Date] that is formatted as follows in my data:

10/4/2018 7:00:00 PM

I have attempted to do the following in my script:

DATE([Event Date], 'MM/DD/YYY') AS eventDATE

I am doing this to get that field to link to other tables. However when I run the script, this creates duplicate values for each date:

10/4/18

10/6/18

etc.

etc

Am i formatting this incorrectly in the script?

nsetty — Tue, 30 Oct 2018 19:46:57 GMT

Try

DATE(Timestamp#([Event Date], 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY') AS [Event Date]

evansabres — Tue, 30 Oct 2018 19:51:21 GMT

When I do this in my script, the output appears as a dash "-"

sunny_talwar — Tue, 30 Oct 2018 19:51:56 GMT

Try this

Date(Floor([Event Date]), 'MM/DD/YYY') AS eventDATE

evansabres — Tue, 30 Oct 2018 19:53:43 GMT

This worked wonderfully, thank you