How to get the Month and year for a date column in query

[sanmaya]

i have a situation , that i want a date should show me month.



i have two dates filed in table that are Due_Date and Close_Date

my condition would be in query is that a column name Month will show the Month value , if the Due_date is not equal to blank then it will show the Month for Due_date value or it will show the Month of Close_date Value.

any help with the query will be appriciated.

[burrina]

Here are a few Examples:

CurMonth: Format(DateSerial(Year(Date()),Month(Date()),Day(D ate())),"mmmm ")
CurYear: Year(Now())

HTH

[sanmaya]

this is not the correct one, i think there should be a if condition with the query. as it "if the Due_date is not equal to blank then it will show the Month for Due_date value or it will show the Month of Close_date Value."

[burrina]

What is the value of Blank?

[sanmaya]

Blank means if the Due_Date is NULL then

[burrina]

Example: Hope this helps.

CurMonth: IIf(IsNull([Due_Date]),0,[CurMnth])
CurMnth: Format(DateSerial(Year(Date()),Month(Date()),Day(D ate())),"mmmm ")