Date Field Display Format without Time Value
Brian Dollen
Merged in a post:
Format how dates appears in body of email message
R
Richard Hubbard
When inserting a date field to be included in an email body for example, the full information is added, ie 'Mon, 15 Jan 2024 00:00:00 GMT' even though the field is just a date (ie no time, but time is being added).
It would be good to be able to format the date so it appears 15/01/2024 or 15 January 2024
Tim Johnson
Agreed. SOFTR, Forms, and Document Designer - or any other means of presenting data to the user/consumer of the data - should all allow for field formats that are different to how the fields are formatted in the table. You may have a valid reason for including the date and time in the field, but shouldn't have to create another field just to show the same data in a different format.
Patrick Szydlik
If you add a formula for the date it will compact it and this could be an easy work around:
DATETIME_FORMAT([Date], "compact")
The Date field in the brackets has to be the name of that field so if it's due date or post date-> it has to say that in the brackets.
You can then use the formula in your emails to have a standard 1/29/24 type format.