Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to remove "time" from this formula

Topic Labels: Formulas
Solved
Jump to Solution
4783 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.