- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2023 09:49 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2023 10:52 AM
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.
