Date parameters

[juneau730]

Happy Friday.

In my dBase, many queries have a >= or <= parameter, like such <=(Date()-365)

Is there a more accurate way to write this? One of the queries using this is missing one item that a different routine (pulling the same data) is picking up.

 

[Joe4]

One of the queries using this is missing one item that a different routine (pulling the same data) is picking up.

This first thing to determine is which one is actually right.
So find out what the value is in the record that is missing, and then determine if it should or should not be included.

I could see how in a leap year, your calculation above might miss one day, and maybe you would want to use different date match to get the same day one day earlier.
However, we are not in a leap year, so the logic above should return the correct date.
So I think you need to investigate the difference. Maybe the logic in your other routine is faulty.

 

[xenou]

Also beware of time data if your dates have times in them.

For instance,

9:15 AM on on Jan 1 (2019-01-01-09:00:15) is not less than or equal to Jan 1 as a date (2019-01-01 00:00:00). Specifically it is 9 hours and 15 minutes greater than Jan 1 as a date.

 

[juneau730]

Thanks for the input Joe4 and xenou. Was able to figure out what was going on. It was a combination of the other source being partially incorrect and my filter missing a "and not" parameter due to how the data queried.

All working correctly now.