Help

Hide Year in a Date field type

2288 3
cancel
Showing results for 
Search instead for 
Did you mean: 
dgobler
4 - Data Explorer
4 - Data Explorer

Is it possible to hide the year in a field with the date field type?

Right now entries show “4/8/2018” I just need the “4/8”.

3 Replies 3

Not in a “Date” field, no.

A workaround might be to make a formula field that takes the date from that “Date” field and displays it as you want with a formula like this:

DATETIME_FORMAT(Date, 'M/D')

image

Francis_Bergero
4 - Data Explorer
4 - Data Explorer

Hi, do you know how to transfert that format (5/17) in a format with texte ? Like may 17th ? I have the same issue, but with a date like this septembre 17th 2021 and I want to hide the 2021. Thanks.

This is a very late reply so I'm sure you have sorted it!

But for anyone reading this thread, you can find a range of date formats here, under the title: Supported DATETIME_FORMAT specifiers.