Show records with date equal to or less than now 1

[epoh]

What formula do I use in Record | Select Expert
to show dates less than the current date and time?

{Hist.RecDate} <= DateTime X
I tried Now(), Now, CurrentTime
none of them worked.

{Hist.RecDate} <= DateTime(Now)
Didnt give me an error but it returned no records.

Thanks

 

[synapsevampire]

Select Report->Record Selection->Record and place:

{Hist.RecDate} <= currentdate

-k

 

[synapsevampire]

also make sure that it's set to Crystal syntax, not Basic.

-k

 

[lbass]

Try:

{Hist.RecDate} <= currentdatetime

-LB

 

[synapsevampire]

Ahhh, right, if you need it for the time, use LB's formula, I overlooked the time requirement.

-k

 

[epoh]

Thank you lbass, that did what I wanted.