Date count

[Danny00lee]

I am trying to use < = > in a criteria to find out how many days are left before an items expires (Expires date: Future Date - Date() ) and list it out. For example: 0-30 days left, 31-60 days left, etc...). I'm missing something in the calculation. Thanks in advance.

 

[Megacitizen]

I'd drop the '=' bit and just use '<>', which is basically "not equal to". Failing that, use '<=' and '>=' as seperate expressions.

 

[pr2-eugin]

I am not sure what you are trying to do there..

* If you are trying to find the number of days between the Future Date and the present Date then you will so much better off with DateDiff("d",[Future Date],Date())

* If you are trying to find the date if falls between two dates then use the suggestion put forward by Megacitizen or also can use Between someDay And someOtherDay