combine date if conditions are met

**paweaver** · 2012-02-22 11:34

I tried some code like this in a query using IIf
If [StartDate] = [EndDate], Then just print [StartDate], else [StartDate] "thru" [EndDate]
It just displays a null field.

**MarkLiquorman** · 2012-02-22 13:46

If your StartDate is null, the result will be null. Assuming it isn't null, this should work:

IIF([StartDate]=[EndDate],[StartDate],[StartDate] & " thru " & [EndDate])

**paweaver** · 2012-02-23 09:12

I tried that formula. However, only the true part works, ie Start date.
what does not work is the false part. for some reason it displays nothing. Seems it is being confused by 2 date fields and the "thru"
paul

**MarkLiquorman** · 2012-02-23 10:00

Well, I don't know what to tell you. I tried it on a table I had, and it worked perfectly.

**paweaver** · 2012-02-23 10:05

I just tried it on another databse and it worked as well. thanks for the help

Thread: combine date if conditions are met

Thread Tools