Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

converting month year

Hi

i have date format like this

i need  2 fileds form the above field

year and month

how. anyon please help

2 Replies
sasiparupudi1
Master III
Master III

Month(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))

Year(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))

shiveshsingh
Master
Master

=Year(Timestamp(CREATION_DATE,'DD-MMM-YYYY hh:mm:ss'))

=Month(Timestamp(CREATION_DATE,'DD-MMM-YYYY hh:mm:ss'))