Help

Remove time from formula with date

Topic Labels: Formulas
Solved
Jump to Solution
368 2
cancel
Showing results for 
Search instead for 
Did you mean: 
imazurenko
4 - Data Explorer
4 - Data Explorer

I need next result - Text & Date. Date should be in format MM/DD/YYYY. But now as a result I have time also. It is not expected result. Formatting tab is not available for this case. Below I attached the formula I use. I would be grateful if somebody helps me to remove time from my formula.

imazurenko_0-1711969208111.png

imazurenko_1-1711969237401.png

imazurenko_2-1711969287776.png

 

 

 

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Try using DATETIME_FORMAT():

Screenshot 2024-04-01 at 8.45.52 PM.png

 

"DR-" & 
DATETIME_FORMAT(
  AddedOnDate,
  "MM/DD/YYYY"
)

 

 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

Try using DATETIME_FORMAT():

Screenshot 2024-04-01 at 8.45.52 PM.png

 

"DR-" & 
DATETIME_FORMAT(
  AddedOnDate,
  "MM/DD/YYYY"
)

 

 
SobhiS
4 - Data Explorer
4 - Data Explorer

If what you're looking for is the created Date but without the time, then add that column to your table and cater it to your liking then add that to your ID name:  

SobhiS_0-1711977823953.png