Format Cells as a Date

­­General Discussions
1

Trying to format a cell in the Template Studio and would like to have it show just the date (MM/DD/YYYY) rather than the date and time. There doesn’t seem to be any cell formatting for dates of any kind. I can obviously create a formula that takes the information and displays it in a different cell in the correct format. However, having a date format option would be more useful.

2

Thank you for sharing this case Andrew.

Please log in to the feedback forum to add your case and vote for the request. This will be more visible to the product team to analyze it.

Thank you

1 Like
3

I noticed this to as well. I have managed to get around it by making the data string and used the Month(), Day() and year() functions … something along the lines where the original date is hidden the I reference it in a string formula

(assuming my date is in E3)

=CONCAT(MONTH(E3),"/",DAY(E3),"/",YEAR(E3))

3 Likes
4

Hi Andrew,

You an even use the TEXT formula. Let’s say your date is in Cell B1, you could then the formula =TEXT(B1,“MM/DD/YYYY”) and the date (from B1) will now show up in the format you’d like it to be.

Thanks,
Navin

2 Likes