Need a formula to filter for current date

[JSeidel]

what formula could I write that will only show records for the current day's work?

thanks!

 

[cmpgeek]

in the record selection area and this line:

{yourdatefield} = currentdate

that should help... good luck

ShannonLea

 

[bdjb]

Hello,
It shouldn't really be neccesary to use a formula, you can use the Select Expert, and set your data field equal to the desired date (Even use a parameter). If you want it to be a bit more automated, use the Select Expert and select the formula editor to set something like
{Date Field} = "Today". (Today is a built in function).

Hope this helps,
Bob

 

[synapsevampire]

In the record selection formula (report->Edit Selection Formula->Record) try:

{table.datefield} = currentdate

-k

 

[synapsevampire]

bdjb: That builds a formula in the record selection.

-k

 

[bdjb]

Hey synanpsvampire,
You're right, it does build a formula. I guess I was so happy to be finally able to answer a question, I got ahead of myself. Hopefully we all managed to answer JSeidel's question.

 

[synapsevampire]

bdjb: No worries, your answer was correct, though I tend to steer folk away from the select expert as it can generate some erroneous criteria at times, and it might also prevent SQL from being passed to the database.

-k