Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you use interval match without Id's?
I have an orders table containing ordered dates, I want to use interval match to get all orders for a current period, future and all orders year to date.
can any one help?
Best practice for doing this is to use a calendar and not IntervalMatch. It might certainly be use cases that are valid for doing an IntervalMatch but without having more details I would suggest that you have a very close look at how a calendar with fields and flags for various standard periods can help you.
here is one link that might help