Have Date Field Display "Today"

[JamesJoey]

I'd like to get a date field to display "Today" if the value of the field is =Date() (today).

Any ideas?
James

 

[plog]

What have you tried?

https://www.techonthenet.com/access/functions/advanced/iif.php

 

[Mark_]

I'd like to get a date field to display "Today" if the value of the field is =Date() (today).

Any ideas?
James

Is this in a report? Is this is a non-editable field on a form? Or do you want an end user to type in "Today" and have this convert?

Please provide more detail on where you want to display this.

 

[JamesJoey]

This is a form and the field is editable.
I really haven't tried anything yet.
I'm currently displaying "Today" using the IIF but I'm unable to edit the date if I want to:

SELECT IIf([ReminderDate]=Date(),"Today",Format([ReminderDate], "ddd mmm dd")) AS Expr1, * FROM tblReminders WHERE (((ReminderDate)<Date()+7)) ORDER BY ReminderDate, ReminderTypeID, Reminder;[/CODE

Using this I am unable to bring up the date picker.

 

[Mark_]

Correct, you would not.

Expr1 says it is a computed field, thus not editable. Personally I would not try to fill it with "Today", I would set the fields background colour based on the date. If today make it blue. If older, make it red. If in the next N days, yellow, otherwise green.

Trying to change the value itself won't be as helpful in the long run, especially as this is a reminder DATE. You want them to see the date.

 

[missinglinq]

Everything else aside...if this is a DateTime Field...it can't display 'Today,' which is text.

Linq ;0)>

 

[JamesJoey]

I see now.

I never thought of using Conditional Formatting.

Thanks much

 

[JamesJoey]

Actually what I did was[lace a label next to the date field and in the On Current checked to see if the record's date value is =Date().
Seems to work ok.