
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 19, 2019 10:35 PM
This formula from the blog produces the result with at time: 9/30/19 12;00am
What part of the formula needs to change to eliminate the time?
DATETIME_PARSE(DATETIME_FORMAT({Period},‘MM/DD’)&"/"&YEAR(NOW()))
Thank You
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 21, 2019 06:31 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 21, 2019 06:31 AM
You should be able to toggle off the time component on the formatting tab.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 21, 2019 10:10 AM
Thank You! I tried replying to this with a thumbs up but it wouldn’t accept it?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 24, 2019 03:03 AM
You can just click the thumbs-up icon at the bottom of the comment from @David_Skinner. Also, if his reply solves your problem, click the check box to mark that comment as the solution.
