- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 14, 2023 11:05 AM
I have a Date field (Date Asset Added) whose value is entered manually formatted like this:
12/8/2023
Another field (Date RM) contains this formula:
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 14, 2023 01:23 PM
Hi Ella, thanks for that tip, which worked!
I got into trouble when I tried wrapping the DATEADD function inside a DATETIME_FORMAT function which changed the field type from Date to Text.
And all I had to do was turn off including time.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 14, 2023 12:47 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 14, 2023 01:23 PM
Hi Ella, thanks for that tip, which worked!
I got into trouble when I tried wrapping the DATEADD function inside a DATETIME_FORMAT function which changed the field type from Date to Text.
And all I had to do was turn off including time.
