criteria and dates

  • Thread starter Thread starter kryszystof via AccessMonster.com
  • Start date Start date
Sorry,

i have a query, and i want to create an expression that depends on a date
field.


i have

Field1 | Field2
Date Expr

field 2is such: adj1: iif([DateField] >= "01/01/2002",[do calculation], " ")

i think it has to do with the date format that i am searching by, or possibly
syntax?

TIA,
~K
 
wow!, I fixed my problem myself!

thanks to anyone who might have wrote back!

(i removed quotes~ works like charm)
kryszystof said:
Sorry,

i have a query, and i want to create an expression that depends on a date
field.

i have

Field1 | Field2
Date Expr

field 2is such: adj1: iif([DateField] >= "01/01/2002",[do calculation], " ")

i think it has to do with the date format that i am searching by, or possibly
syntax?

TIA,
~K
Hello to all,
Click to expand...
Click to expand...
 
Nevermind, I still need help!

more ways than one! lol
wow!, I fixed my problem myself!

thanks to anyone who might have wrote back!

(i removed quotes~ works like charm)
Sorry,
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
Back
Top