Date formatting in script

[WernerDC]

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

[Vegar]

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]

[WernerDC]

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

[rwunderlich · Accepted solution]

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

[WernerDC]

Perfect. Thank you.

Seems like dates can really push you around