Re: Date Expressions
Try an IIf infront of this
IIF([ReleaseDate] > Date(), DateDiff("d",[TowedDate],Date()), DateDiff("d",[TowedDate],[ReleaseDate])
Also check my parentheses and brackets ... think I might have left out one ...
Originally posted by Interstate
I'm trying to figure the difference between two dates in a form using the table field in the following expression which is in the control source of DaysStored
This is working properly.
My problem is that I need to have an expression that takes into account the ReleaseDate and if this date is less than Todays date the field needs to be filled with the difference between TowedDate and ReleaseDate.
Sorry if this seems like a simple question but I'm about 4 days into working with Access 2002 and this is a bit confusing.
Life is too short to be sane or sensible. Weird people rule and normal people suck