Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create a year week and month from date

my date format is in 03/march/2013

1 Solution

Accepted Solutions
Not applicable
Author

thanks for your response but it is not working

i tried in this way it is working

month(Date(date#(DATE,'DD-MMM-YY'),'MMM'))

  Year(Date(date#(DATE,'DD-MMM-YY'),'YYYY'))

    Week(Date(date#(DATE,'DD-MMM-YY'),'W'))

View solution in original post

3 Replies
Not applicable
Author

Try below expressions.

=Year(Date#('03/march/2013','DD/MMM/YYYY'))

=Month(Date#('03/march/2013','DD/MMM/YYYY'))

=Week(Date#('03/march/2013','DD/MMM/YYYY'))

Not applicable
Author

thanks for your response but it is not working

i tried in this way it is working

month(Date(date#(DATE,'DD-MMM-YY'),'MMM'))

  Year(Date(date#(DATE,'DD-MMM-YY'),'YYYY'))

    Week(Date(date#(DATE,'DD-MMM-YY'),'W'))

View solution in original post

MayilVahanan

Hi

Try like this

= Date(date#('03/march/2013','DD/MMM/YY'),'MMM') for month

Note:

Mention as per your format.

Ex: 03-march-2013 is your format


=month(Date(date#('03-march-2013','DD-MMM-YYYY'),'MMM'))

Hope it helps


Thanks & Regards,
Mayil Vahanan R