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
How to remove "time" from this formula
Best answer by David_Skinner
You should be able to toggle off the time component on the formatting tab.
+21Thank You! I tried replying to this with a thumbs up but it wouldn’t accept it?
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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.