Pipeline shows 0 records found?
Made a scheduled pipeline to look at a "formula - duration" field on Table A (Calendar) that signifies how many days until an event there are. If it is between 0-75 days, it should create a new reco...
Forum Discussion
I've ran into something similar with trying to determine if a record is less than a duration value. I'm not sure why but it appears the function for seconds is adding zeros (000). When you set the duration field to seconds, it will display appropriately. However, if you use the formula builder, you'll see 3 extra zeroes added. This value is also true in pipelines, even though you might expect the value for a full day in seconds to be 86,400, you'll get 86,400,000.
One of my examples was to look at something within a duration of 4 days. In pipelines if I multiple the total seconds by 1000, I get results that I'm looking for.
Very strange indeed.
- MarkShnier__You
Qrew Legend
It's not strange. It just means that they store Duration fields in Milliseconds.
Strange from the end users perspective in that I've asked for seconds, yet I don't get the data that way. End users should not have to concern themselves with data storage.
