Dates as Text

J

judyblue

Hi,

I have a linked table from another program that I cannot change the format
on. They have dates as text and I'm trying to run a query that will return
DateDiff <0 and DateDiff >3. Here is what I've done so far.

Expr1: Format(DateValue([PDATE]),"mm/dd/yyyy")
Expr2: Format(DateValue([DDATE]),"mm/dd/yyyy")

This returns the dates in proper format. My question is, how would I
formulate this in the query to show null values as well as the two mentioned
above?

Hope this makes sense.

Thanks in advance,
Judy
 
Top