Year only

[tmumaw]

Can someone please explain why I can't get just the year using this:

Year([Valid Frm Date]) as [Valid Year], my date format is YYYY-MM-DD

[Digvijay_Singh · Accepted solution]

One possibility could be that your field has not interpreted as date, you may need to use this -

Year(Date#([Valid Frm Date],'SourceFieldformat')) as [Valid Year], my date format is YYYY-MM-DD

Use 'YYYY-MM-DD' in place of sourcefieldformat if the source data has this format.

[sunny_talwar]

Good readings on this topic

Why don’t my dates work?

QlikView Date fields

Get the Dates Right

[tmumaw]

Thanks.  Running into a few problems from our upgrade this past weekend.  New server, new release of QV 12.20, new SAP Connector......