date 11 jan 2011

[#1]

in my date field 11 jan 2011

how to retrive the month ,date year

[tresesco]

Date(Date#(YourField, 'DD MMM YYYY')) as Date

Month(Date#(YourField, 'DD MMM YYYY')) as Month

Year(Date#(YourField, 'DD MMM YYYY')) as Year

[Anonymous]

Hi,

Try below,

Date(Date#('11 jan 2011', 'DD MMM YYYY')) as Date,

Day(Date#('11 jan 2011', 'DD MMM YYYY')) as Day,

Month(Date#('11 jan 2011', 'DD MMM YYYY')) as Month,

Year(Date#('11 jan 2011', 'DD MMM YYYY')) as Year

[#4]

these are not working

[its_anandrjs]

Try like below scripts what is your date format.

Date(Date#(YourDateField, 'DD MMM YYYY'),'DD/MM/YYYY') as Date

Or

//For Date use below scripts

MakeDate(Year(Date#(Right('11 jan 2011',4),'YYYY')), Month(Date#(mid(Da,4,3),'MMM')),Day(Date#(Left('11 jan 2011',2),'DD'))) as DateField

Month(Date#(YourDateField, 'DD MMM YYYY')) as Month

Or

Month(Date#(mid('11 jan 2011',4,3),'MMM'))

Year(Date#(YourField, 'DD MMM YYYY')) as Year

Or

Year(Date#(Right('11 jan 2011',4),'YYYY'))

[alexandros17]

Try simply these

Month(YourField) as Month

Year(YourField) as Year

Let me know