Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
The formula expression is invalid: Formula result is data type (Date), incompatible with expected data type (Date/Time). I tried TODAY()
The formula function TODAY() returns a Date value. If you need the current Date and Time, you want NOW(), which returns a Date/Time value.
The formula function you need here is NOW() - this similar to TODAY() in that it returns the appropriate value when the formula is assessed, but it will return a date/time rather than just a Date.
Required, but never shown