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.
Go to Solution.
Year(Date#(FieldName, 'M/D/YYYY hh:mm TT')) as Year
Year(Date#(FieldName, 'MM/DD/YYYY hh:mm TT')) as Year
Great ! it's work - Thank you!