
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 29, 2017 02:35 PM
Hi,
It appears, that by default, the function for TODAY( ) will show today’s date PLUS an (incorrect) time-stamp. I can’t seem to get rid of the time. Currently I have the formula set to: TODAY('MM/DD/YY')
To add to that, it shows the wrong date format, too: 5/29/2017 12:00am. (it’s not 12 am, by the way).
Anyway, I’d like it to show in the MM/DD/YY format without the time stamp. Is this possible?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 29, 2017 02:57 PM
Well, I spoke too soon. Jimmy’d a way to do this:
DATETIME_FORMAT(TODAY(), 'M/DD/YYYY')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 29, 2017 03:28 PM
Alternatively, you could use the “Formatting” tab:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 29, 2017 03:47 PM
Oh, well, there ya go. I’m always wanting to complicate matters :winking_face:
