Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to remove "time" from this formula

Topic Labels: Formulas
Solved
Jump to Solution
2123 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

image

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

See Solution in Thread

3 Replies 3

image

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?

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.