Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Trying to extract Month and Year from Date via Dataload Script

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.

 

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

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

View solution in original post

3 Replies
Highlighted
Master II
Master II

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

View solution in original post

Highlighted
Creator III
Creator III

HI,

 

Year(Floor(Datefield)) as year

Month(Floor(Datefield)) as Month

 


-Somasundaram
Highlighted
Contributor III
Contributor III

Oh thanks this worked!