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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Labels (1)
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'))