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.

Creating If statement formulas with a column that has both date and time

Topic Labels: Formulas
735 1
cancel
Showing results for 
Search instead for 
Did you mean: 
blmahon
4 - Data Explorer
4 - Data Explorer

I have content creation table that has a field for date and time.  I am trying to create a formula similar to this 

 

If ( {Date to Post}=TODAY( ), "Post")

 

but it is throwing an error and I wonder if it is because my column has both date and time.

 

this is the youtube video that was helping me.  https://www.youtube.com/watch?v=pai7nmnLh6g

 

But i can't get past entering the formula.

 

Any help would be appreciated.

1 Reply 1
Ben_Young1
11 - Venus
11 - Venus

Hey @blmahon

I've never had a reason to use the IS_SAME() function, but I think today is that day!
Give this formula a shot:

IF(
    IS_SAME({Date to Post}, TODAY(), "day"),
    "Post"        
)

Here's the behavior it returned me when I tested it:

Ben_Young1_0-1675795801827.png

As a side note, it might not be totally relevant or applicable to your use case, but your post reminded me about this thread from yesterday. Might be worth a look to see if it might support or influence your solution a bit.