Compare dates in 2 unbound text boxes

[Bosworth]

On a form I'm asking a user to enter dates in 2 different textboxes, say, [text1] and [text2], both formatted to short date. In a third textbox [text3] I need to see the date of the greater of the two, and in a fourth [text4] I need to see the date of [text3] if it falls on a Monday through Friday, or the date of the previous Friday if [text3] falls on Saturday, and the date of the following Monday if [text3] falls on a Sunday.

...a couple quick examples;

If text1 = 2/20/2015 and text2 = 2/27/2015, text3 should evaluate to 2/27/2015, and text4 should evaluate to 2/27/2015
or
If text1 = 2/20/2015 and text2 = 2/28/2015, text3 should evaluate to 2/28/2015, and text4 should evaluate to 2/27/2015


My attempts to compare text1 and text2 revolve around an IIF but result in an error...

Entering this into [text3]... IIF([text1]>[text2], [text1], [text2])

...results in "#Name?" error, which I interpret as meaning the date from the source cannot be pulled into the formula.

In attempt to check the day of week, I used =Weekday([text3],1) which results in a number. I haven't been able to do an IIF on it as it errors with #Name? again. I've tried a couple other ideas but nothing is bearing fruit. Please give me a nudge in the right direction.

TIA
Bos

[trevor40]

try # around the dates. #1/1/2015#

[June7]

#Name? means Access can't find something that is referenced in the expression. Make sure names are spelled correctly and that you have = sign at beginning of the expression.

[Bosworth]

Thank you Trevor40 and June7.

Amazing what happens when you use the right syntax. Just needed the "=" in front of the IFF. Should have known better.

Bos