how to create a year week and month from date

[#1]

my date format is in 03/march/2013

[#2]

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'))

[#3 · Accepted solution]

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'))

[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