Date functions in query filter ?? - Impromptu

[panderson]

Here is an Impromptu neophyte question: How do I get the date functions to work in a query filter. I have tried filters such as ApptDate = today () where ApptDate is the name of a data column, but this returns zero records. Query filters with numeric or string data seem to work fine for me. I assume I am making some type of syntax error, but can't find any online documentation in the program to correct it.

Thanks.

 

[Emili]

Forget about a syntax error because impromptu doesn't let you close the expression windows unless the exprssión is syntax validated.

Why don't you try with now() instead of today()?

Good luck,
Emilio

 

[TeckDave]

The Today function uses the date that is on your local PC/workstation. The now function uses the date that is on the server that you are attached to.

A reason you see 0 data could the database does not have todays data in it? Try using the today function and reset your date on the PC back one day and re run the query to see if it works. It could be a matter of the date select for the data update into the database.

 

[griffindm]

If the data element is a datetime, rather than a date, you may have to strip off the time element to get an exact match for the filter. Check out the datetime-to-date function.