SV18
Board Regular
- Joined
- Sep 1, 2008
- Messages
- 157
Hello Everyone,
I need a query to select only cases from my main table that have 'Todays' date in.
Obviously today will change with each day.
I've tried the date() expression but as there are times in the field too it ignores everything.
I think it needs to be something like between 'Date() time(0:00:00) and Date() time(23:59:59) but I can't get this to work.
The reason I need this is because I'm trying to create a diary function that will show the user if they have any call backs to make on the day they enter the database.
Can anyone help
I need a query to select only cases from my main table that have 'Todays' date in.
Obviously today will change with each day.
I've tried the date() expression but as there are times in the field too it ignores everything.
I think it needs to be something like between 'Date() time(0:00:00) and Date() time(23:59:59) but I can't get this to work.
The reason I need this is because I'm trying to create a diary function that will show the user if they have any call backs to make on the day they enter the database.
Can anyone help