Last 1/2 Hour - Yet another Time Question

[rsunra]

G'day All

I know you ladies and Gent should be able help me

I need to get all data for a report that will include the last 1/2 only

Cheers

Rich

 

[Madawc]

In Crystal 8.5, you need DateDiff, which handles time as well. Assuming it's from the current date;
DateAdd("n", -30, currentdate)

This will give you a formula field for a time and date 30 minutes ago, which you cna then use in selection

Madawc Williams
East Anglia, Great Britain

 

[lbass]

I think Madawc probably meant:

DateAdd("n", -30, currentdatetime)

-LB

 

[Madawc]

lbass is right, of course. Oddly enough, Crystal 8.5 will let you subtract half an hour from the current date, but will give you half an hour before midnight on the previous day. When you say currentdatetime, you get half an hour before the current time.

Madawc Williams
East Anglia, Great Britain