Help Match two dates as same

[eddii]

i have two fields or expressions

sysduedate date format ( mm/dd/yyyy )
it has 04/28/2011 ( apr/28/2011 )

and

Nextduedate date format ( mm/dd/yyyy )
it has 04/08/2011 ( apr/08/2011 )

both are tables are joined by a query

now i am not able to match because days are different

how to only match month and year
like apr/2011 and apr/2011 so that it matches and i get result matches

 

[John Big Booty]

You could use the DatePart() function to extract the Year and Month form the two dates and compare those.

 

[eddii]

In DatePart() how to use to get month and year

it gives only month or year

 

[vbaInet]

eddii,

You have it already in your OP. Format it to only include the Month (i.e. mm) and Year (i.e. yyyy)

 

[John Big Booty]

In DatePart() how to use to get month and year

it gives only month or year

Use the And operand or as vbaInet suggests use Format Function (with Dates) to reduce the dates to mm/yyyy format.

 

[eddii]

thanks : Re: Help Match two dates as same

thanks vbaInet
thanks John Big Booty

i will do it and get back to you tomorrow

thank you once again for the fast response

 

[eddii]

Thank you very much Re: Help Match two dates as same

vbaInet & John Big Booty
Thanks you very much

i have used

formatfor: Format([nextcalduedate],"mm/yyyy")

i got the problem solved by using format function but will it work if i give in
query properties format directly to [nextcalduedate]

 

[vbaInet]

Re: Thank you very much Re: Help Match two dates as same

i got the problem solved by using format function but will it work if i give in
query properties format directly to [nextcalduedate]

You will need [nextcalduedate] in the same format too.

 

[eddii]

thanks vbaInet

thanks for teaching, now iam able to understand things how they work as old was in text format

 

[vbaInet]

Glad we could help!