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