+2I 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.
Best answer by TheTimeSavingCo
Try using DATETIME_FORMAT():
"DR-" &
DATETIME_FORMAT(
AddedOnDate,
"MM/DD/YYYY"
)
+31Try using DATETIME_FORMAT():
"DR-" &
DATETIME_FORMAT(
AddedOnDate,
"MM/DD/YYYY"
)
+2If 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.
