Skip to main content

Function: Enable TODAY( ) without a time-stamp

  • May 29, 2017
  • 3 replies
  • 68 views
M
Forum|alt.badge.img+4

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?

    3 replies

    M
    Forum|alt.badge.img+4
    • Megan_Dunagan
    • Author
    • Known Participant
    • May 29, 2017

    Well, I spoke too soon. Jimmy’d a way to do this:

    DATETIME_FORMAT(TODAY(), 'M/DD/YYYY')

    K
    Forum|alt.badge.img+4
    • Kasra
    • Inspiring
    • May 29, 2017

    Alternatively, you could use the “Formatting” tab:

      M
      Forum|alt.badge.img+4
      • Megan_Dunagan
      • Author
      • Known Participant
      • May 29, 2017

      Alternatively, you could use the “Formatting” tab:


      Oh, well, there ya go. I’m always wanting to complicate matters :winking_face:

      Terms & ConditionsAccessibility statement