T
Theman
Guest
I have two fields one is called RequestCompletionDate and the other is called DupDateDist. I am trying to create a third field in my query called Days Pending which would capture the difference in days between the date in the RequestCompletionDate and the empty value in DupDateDist. This would tell me how long it is taking the product to get distributed from the completion date. So if the RequestCompletionDate field has 7/31/01 as a value and there is no value in DupDateDist, then the Days Pending value should be 3 if I ran the report today (8/2/01). I used the datediff like this in my query field:
"Days Pending: DateDiff("d",[DupDateDist],[requestcompletiondate])
However, the Days Pending won't display any value. What am I missing here? Thanks.
Dan
"Days Pending: DateDiff("d",[DupDateDist],[requestcompletiondate])
However, the Days Pending won't display any value. What am I missing here? Thanks.
Dan