This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have some product, and the date they have been created
I also have a DB that returns me a value (Time) if the production end date (Prod-End) is between the Start and End dates
I dont know if it's because my brain is stuck in flu i can't figure how to make it works
Go to Solution.
Go to Solution.
Looks like you want to start out with an inner join on the two data sets with [Product] = [Product].
Then use the multifield formula to say (for a new named field)
IF [Prod-End] > [Start] and [Prod-End] < [End] THEN 0 ELSE 1 ENDIF
This should flag all product line entries that were created outside of the date range with a "1".
Hope this helps.
EDIT: You can also use the filter function after the join and filter the date based on the above stated criteria.
Maybe i'm not clear in my explanation
For this example
It should return me 5 for that entry because its between those 2 dates
My apologies, I misunderstood.
The following change should accomplish what you are looking for:
IF [Prod-End] > [Start] and [Prod-End] < [End] THEN [Time] ELSE 0 ENDIF
This will return 0 when it's not between those 2 dates and the value in the [Time] field when it is. Feel free to replace 0 with whatever you want to show up when it isn't between the date range.
Let me know.
Thanks that's a good idea, after that formula i applied a filter to remove all 0 to keep only the good data