topic Re: Date formatting in script in QlikView

Date formatting in script

WernerDC — Sat, 16 Nov 2024 03:50:26 GMT

Hi,

I am having trouble with converting dates to Month and year.

This is what I did:

Date#(@2) AS [WEATHER DATE],
Year(Date#(@2)) AS [WEATHER YEAR],
Month(Date#(@2)) AS [WEATHER MONTH]

When I do list boxes, only the Date 1 displays data. Not Year nor Month shows any data?

I also tried this:

Date#(@2) AS [WEATHER DATE],
Year(Date(@2)) AS [WEATHER YEAR],
Month(Date(@2)) AS [WEATHER MONTH]

Also no success.

Please advise

Re: Date formatting in script

Vegar — Tue, 16 Apr 2019 13:55:35 GMT

You should specify which format your date in @2 is stored.
If today is stored as 2019-04-16 then you should type 'YYYY-MM-DD' like below

dayname(Date#(@2,'YYYY-MM-DD')) AS [WEATHER DATE],
Year(Date#(@2,'YYYY-MM-DD')) AS [WEATHER YEAR],
Month(Date#(@2,'YYYY-MM-DD')) AS [WEATHER MONTH]

Re: Date formatting in script

WernerDC — Wed, 17 Apr 2019 07:23:52 GMT

Thank you for the response.

It however still does not work?

(Date#(@2,'DD-MM-YYYY')) AS [WEATHER DATE],
Year(Date#(@2,'DD-MM-YYYY')) AS [WEATHER YEAR],
Month(Date#(@2,'DD-MM-YYYY')) AS [WEATHER MONTH],

And

dayname(Date#(@2,'DD-MM-YYYY')) AS [WEATHER DATE],
Year(Date#(@2,'DD-MM-YYYY')) AS [WEATHER YEAR],
Month(Date#(@2,'DD-MM-YYYY')) AS [WEATHER MONTH],

Please advise

Re: Date formatting in script

rwunderlich — Wed, 17 Apr 2019 07:41:40 GMT

It appears your input date uses / as the separator, so you should specify:

'DD/MM/YYYY'

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Date formatting in script

WernerDC — Wed, 17 Apr 2019 08:09:58 GMT

Perfect. Thank you.

Seems like dates can really push you around