How do I get out part of a date in a query??

[fenerfan]

Hey People,

Is it possible to take out part of a date in a query and put it into a new column, e.g.

if one field is : "Date"... with entries such as 12/05/07.. etc,

is it possible to have another column "Month" that has the specific month in the date column.. e.g the one above will have "May".......

anyone have any idea about this...

cheers.

 

[fenerfan]

sorry mate didn't work...

MyMonth: DatePart("mmm",[Date_Rasied])

here is what it returned:

Equipment_Name Event Date_Rasied MyMonth
sump pump 609359 12/06/2007 #Error

 

[ColinEssex]

MyMonth: Format([YourDateField],"mmm")

Col

 

[neileg]

sorry mate didn't work...

MyMonth: DatePart("mmm",[Date_Rasied])

here is what it returned:

Equipment_Name Event Date_Rasied MyMonth
sump pump 609359 12/06/2007 #Error

Should be
MyMonth: DatePart("m",[Date_Rasied])

 

[Rich]

Why do you want to do this in a query?

 

[Ron_dK]

Is it possible to take out part of a date in a query and put it into a new field , ....have another field "Month"

In your query create a field :
Month1: DatePart("m",[Date_Rasied])
and another :
MName: MonthName([Month1])

Hth