Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sahajaqlik
Contributor

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
Honored Contributor III

Re: converting month year

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
Honored Contributor

Re: converting month year

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

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

Community Browser