- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2024 04:03 AM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2024 05:46 AM
Try using DATETIME_FORMAT():
"DR-" &
DATETIME_FORMAT(
AddedOnDate,
"MM/DD/YYYY"
)
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2024 05:46 AM
Try using DATETIME_FORMAT():
"DR-" &
DATETIME_FORMAT(
AddedOnDate,
"MM/DD/YYYY"
)
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 01, 2024 06:23 AM
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:
