Help

How to remove "time" from this formula

Topic Labels: Formulas
Solved
Jump to Solution
3557 3
cancel
Showing results for 
Search instead for 
Did you mean: 
PC1
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
David_Skinner
9 - Sun
9 - Sun

image

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

See Solution in Thread

3 Replies 3
David_Skinner
9 - Sun
9 - Sun

image

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

PC1
5 - Automation Enthusiast
5 - Automation Enthusiast

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.