Help with trim

[#1]

Hi guys

I am trying to trim a date field so i have just the year. I have searched the net to no avail. Ihave tried this but no luck, Please could someone help ?

Payment_A_Date,Left(Payment_A_Date,4)

as myYear,

[roger_stone · Accepted solution]

In the script:

YEAR(Payment_A_Date) AS myYear

[sunny_talwar]

Try this:

Year(Date#(Left(Payment_A_Date, 4), 'YYYY')) as myYear

[buzzy996]

year(urfieldname)