Hi,
I'm connecting to an Oracle DB, and I want to create a field that pulls just the year out of a datetime field.
So, I'd want 2017-01-02 to result in a value of 2017, which needs to be in integer format.
Thanks for your help!
Solved! Go to Solution.
hi @estherb47,
Have you tried:
ToNumber(DateTimeFormat([DateTime_Field],"%Y"))
That just might work.
Cheers,
Mark
ok... how about:
EXTRACT(year FROM order_date)
i can webex with you now....
Cheers,
Mark
Can't WebEx on this because it's very sensitive data.
You solved it for me. Thank you!!! See you soon @ Inspire
Yeah! One more solve before Inspire.
Cheers,
Mark