Remove time from formula with date

[imazurenko]

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.

[TheTimeSavingCo · Accepted solution]

Try using DATETIME_FORMAT():

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

 

[SobhiS]

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: