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.
Try using DATETIME_FORMAT():
"DR-" &
DATETIME_FORMAT(
AddedOnDate,
"MM/DD/YYYY"
)
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.