Trying to extract Month and Year from Date via Dataload Script

[Keitaru]

Hi

I'm trying to extract  Month and Year from my given date format  14/12/2018 11:47:35

I've tried both Month(date_data) and Year(date_data)

but getting  null value with in my table after i loaded the script.

[Frank_Hartmann · Accepted solution]

try like this:

Year(Timestamp#('14/12/2018 11:47:35','DD/MM/YYYY hh:mm:ss')) as Year
Month(Timestamp#('14/12/2018 11:47:35','DD/MM/YYYY hh:mm:ss')) as Month

replace '14/12/2018 11:47:35' with your Timestamp Field

[Somasundaram]

HI,

Year(Floor(Datefield)) as year

Month(Floor(Datefield)) as Month

[Keitaru]

Oh thanks this worked!