Skip to main content
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'))