Query - System Date

[scgoodman]

Have a field called COB (Cleared on-board).
If this is blank and system date is greater than or = to 48 hours...I need to this appear on my report.

Condition

Please help.

 

[KeithG]

I don't understand can you explain more in depth?

 

[raskew]

Hi -

system date is greater than or = to 48 hours...

Got to ask. System date is >= ... Greater than what?

Bob

 

[scgoodman]

I need to perform a calculation in my query that is the field is null and the system date is greater than or = to 48 hours to appear on my report.

Does this help?

 

[KeithG]

What are you comparing the system date to?

 

[scgoodman]

Sorry, I am losing it today.
I have a Picked up date, and if it has not cleared customs and the field is null and 48 hours past the system date then I need to report it.

 

[KeithG]

try datediff('H',[Picked Up date],nz([COB],Now()))>48

 

[scgoodman]

This wants me to put in parameters...for example. Enter Pick up date and enter COB date. I already have the Pickup Date. I need to validate that if the COB field is null and pickup date is greater than or = to 48 hours of the system date...show on the report.