Trouble with Text field: IIF() & Dates

[the problem]

I would like the IIF() statement to display Today's date if [StartDate]=[EndDate]. If not, I would like to display the phrase [StartDate] to [EndDate].



However, it's not working and it reverts to the second code every time.

=IIf([Forms]![DateRange]![StartDate]=[Forms]![DateRange]![EndDate],"=Date()","="Forms![DateRange]![StartDate]" & "-" & "Forms![DateRange]![EndDate]"")

.

=IIf([Forms]![DateRange]![StartDate]=[Forms]![DateRange]![EndDate],"=Date()","Forms![DateRange]![StartDate] -  Forms![DateRange]![EndDate] ")

[jzwp11]

I'm not sure where you are trying to do this (it might make a difference), but if you want to display today's actual date (i.e. the value 7/25/2012), the IIF() would look like this

IIF(forms!daterange!startdate=forms!daterange!endd ate, date(), .....)


Let's assume that the values in startdate and enddate are 7/1/2012 and 7/31/2012 respectively; do you want the false part to display 7/1/2012 - 7/31/2012 or the text value: [StartDate] to [EndDate]

If you want to see actual dates 7/1/2012 - 7/31/2012, the IIF() would look like this

IIF(forms!daterange!startdate=forms!daterange!endd ate, date(), forms!daterange!startdate & "-" & forms!daterange!enddate)

[JoeM]

Try this:

=IIf([Forms]![DateRange]![StartDate]=[Forms]![DateRange]![EndDate],Date(),Forms![DateRange]![StartDate] & " - " & Forms![DateRange]![EndDate])

Edit: Dang my slow typing skills! Looks like you already have a reply that says pretty much the same thing as the formula I came up with!

[the problem]

WHAT WHAT!!!!!!!! SO AWESOME. Thanks guys you both are the best! Solved!!!!!!

How do I change it to solved?

[jzwp11]

You're welcome!

[JoeM]

Your welcome also. Just remember - everything put between double-quotes is treated as literal text, so you do not want to put your variables between double-quotes if you are looking to return their value.

As for marking a thread as "Solved", see here: https://www.accessforums.net/forum-s...lved-1828.html

[jzwp11]

You know, I could not find anything in the FAQ on how to mark a thread as solved, but I think only the original poster can do that. I believe that there are some thread tools that you can use.

Oops I see JoeM has provided a link

[the problem]

Thanks again! I appreciate the information on the double quotes.