Age in days

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

I have a table with Date_Rec and Date_Awarded i would like the followig in
days;

Date_Rec-Date() Where Date_Awarded = "Null"

Could someone assist?
 
A date field can't equal the string "Null". Actually you can't compare any
value to Null since Null is about the same as unknown.

If you want to check for null, use:
WHERE [Some Field Name] Is Null
 
I have a table with Date_Rec and Date_Awarded i would like the followig in
days;

Date_Rec-Date() Where Date_Awarded = "Null"

Could someone assist?
Click to expand...

Use a criterion of

IS NULL

just as I wrote it, with no = or quotes, on the Date_Awarded field; and

Age: DateDiff("d", [Date_Rec], Date())

as a calculated field.
 
Back
Top