Discussion board where members can get started with Qlik Sense.
I have date field in the following format: 6/29/2017 10:35 AM.
I want to extract the year from the field, i try the function year but it doesn't work.
to extract the year you can use this verison :
Year(Date#('2019-07-28 00:00:00.0000000', 'YYYY-MM-DD hh:mm:ss.0000000')) as Year
you just have to change the hard date to the your date field name
Year(Date#([Your_Date], 'YYYY-MM-DD hh:mm:ss.0000000')) as Year