Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Perfect. Thank you.
Seems like dates can really push you around