Hi Friends

[krishna20]

Hi friends

i'm having  a date field not in correct format.Its in numeric value. I need to get the only year in the straight table.How can i fetch it .Can anyone suggest me how to do it?ASAP.

Regards

Krishna

[Gysbert_Wassenaar]

=Year(MyDateField)

[ashfaq_haseeb]

Hi Kalyan can you post some sample records

Regards

ASHFAQ

[PradeepReddy]

Try the bellow thing

DateField	Function
41003	Year(DateField)
20120404	Year( Date#(DateField, 'M/D/YY'), 'YYYY-MM-DD')

[#5]

HI,

If you have year in format 10052007 and you just want to get year

then you can use

right(datefield,4) as Year

this will give you 2007

and if you have year in format

20070531

then you can use

left(datefield,4) as Year

thanks

sudhanshu shrivas