How to remove "time" from this formula

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

image

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

1 Like

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.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.