Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to use a / within a filter for a datefield ????
- Thread starter punchplus
- Start date
As you haven't supplied the actual filter you are using I can only guess at the answer.
I suspect that you are not putting quote marks around the date so if you have something like
datum > 07/26/2004
it is trying to divide 7 by 26 and then by 2004 which will appear to be an Arithmetic expression.
You should have something like
datum > '07/26/2004'
However, if your DateSeparator is defined as -
then you need to do something like
datum > '07-26-2004'
Andrew
Hampshire, UK
I suspect that you are not putting quote marks around the date so if you have something like
datum > 07/26/2004
it is trying to divide 7 by 26 and then by 2004 which will appear to be an Arithmetic expression.
You should have something like
datum > '07/26/2004'
However, if your DateSeparator is defined as -
then you need to do something like
datum > '07-26-2004'
Andrew
Hampshire, UK
- Status
Similar threads
- Question
- Question
- Question
- Question