Skip to main content

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


You should be able to toggle off the time component on the formatting tab.

Thank You! I tried replying to this with a thumbs up but it wouldn’t accept it?

Thank 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.

Reply


Terms & Conditions