Defining a field in InfoAssist for Today's date.

[Brad Gronli]

I have tried setting up a Define field for today's date using the TODAY function, but only get errors telling me that everything iI have tried inside the () is invalid or unknown. Anyone know how to accomplish this simple task

 

Thank you,

Brad G.

[Debra Waybright]

Use&DATEMDYY. Or if you want a different format, try that after the &DATE (like &DATEYYMD)

[David Beagan]

The TODAY function requires either the fieldname or output format, and returns an alpha value such as A10. Therefore in InfoAssist:

screenshot_2022-05-02_125729.png

But if you employ dwaybright's suggestion, you can:

screenshot_2022-05-02_125648.png

Which gives you much more flexibility with calculations and presentation.