Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Column time + 1 minute

Topic Labels: Formulas
345 0
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

I am trying to auto publish content to my site according to formula in my table.
My curl filter is - filterByFormula={diff}=1.
The filter is working great but it seems my logic is lacking when it comes to determining what formula to use to get {diff} =1.

I have a table that includes a column {publish-date}. {publish-date} is set to US 24hr format.

In my {diff} column I tried IS_BEFORE({publish-date},TODAY(HOUR(8))) and IS_AFTER({publish-date},TODAY(HOUR(8))). It worked for one day then went screwy.

In the end I want content from my table row to appear on my site once the current time is past it’s {publish-date}, specifically after 8 AM of it’s {publish-date} .

0 Replies 0