Skip to main content

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

  • February 7, 2023
  • 1 reply
  • 20 views
B
Forum|alt.badge.img

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

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • 520 replies
  • February 7, 2023

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:

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.


Terms & ConditionsAccessibility statement