Change Date Type Coming Out of Date Interface Tool to Match In-DB Field Date

[estherb47]

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!

[MarqueeCrew]

hi @estherb47,

Have you tried:

ToNumber(DateTimeFormat([DateTime_Field],"%Y"))

That just might work.

Cheers,

Mark

[estherb47]

That looks like what I'd use in the regular formula tool. This is the In-DB
formula tool. Is it the same expression syntax?

--
Esther Bezborodko
*Manager*
201.650.7314 | estherbezborodko@gmail.com
beautycounter.com/estherbezborodko

*Our mission is to get safe products in the hands of everyone.*
[image: Facebook]

[MarqueeCrew · Accepted solution]

@estherb47,

ok... how about:

EXTRACT(year FROM order_date)

i can webex with you now....

https://meetings.webex.com/collabs/meetings/join?uuid=M37I5AUGTGAAM8FCLXJK1FFVRX-UCSL&epwd=7e667c8e0...

Cheers,

Mark

[estherb47]

Can't WebEx on this because it's very sensitive data.

You solved it for me. Thank you!!! See you soon @ Inspire

[MarqueeCrew]

Yeah!  One more solve before Inspire.

Cheers,

Mark