Query Help Needed!!

[SV18]

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

 

[james_lankford]

...but as there are times in the field too it ignores everything.

so what's the data type for that field ?
text ?

 

[Norie]

Why not strip out the time portion?

Then query against the result of that.

 

[SV18]

I see what you mean - I'll try that and let you all know....good thinking