Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, |
In the script:
YEAR(Payment_A_Date) AS myYear
Try this:
Year(Date#(Left(Payment_A_Date, 4), 'YYYY')) as myYear
year(urfieldname)