DateTime Field Calculation

[gkrenton]

Have a table that has a field
modify_date in modify_date DATETIME YEAR TO SECONd format
I want to use this field in a
when statement comparing it to today less 2 days
In access I can do a
modify_date<=date()-2 & get the proper result but seems infomrix is a bit more picky.
What is the syntax for doing this comparision realizing that the 'time' element will never be exact.
- Thanks

Gina

 

[iaguigon]

try this:

modify_date <= current year to day - 2 units day

regards,

Iñaki

 

[gkrenton]

Thanks - that does the trick.

Gina

 

[PaulNewns]

I am trying to get the number of months between two date in a select statement with
'22/06/2005' - edat AS Period

but it returns the only the number of days and i have tried vaious things but seem only get errors. I have also tried UNITS Months but this returns a binary that i can't read. Can anyone help please.