Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
HI,
Year(Floor(Datefield)) as year
Month(Floor(Datefield)) as Month
Oh thanks this worked!