1,392
hi,
Please how to achieve this using C/al
How to check if these dates are consecutive
30/12/2017
31/12/2017
01/01/2018
02/01/2018
03/01/2018
and how to check if these dates aren't consecutive
04/01/2018
06/01/2018
07/01/2018
Best regards
*This post is locked for comments
Choose the temp table which has integer as key, and store the dates in both tables , sort one by date and when you loop through that record, inside repeat try to get the second record which the same entry no. if they both don't match it means they are not consecutive.
Of if you know they are very limited then you could do the same using dimension with an array.
Hello,
thank you for your replies, i'm agree this is the logic but i don't know compare what with what ?!!
Rec.setcurrentkey(key);
Rec.setfilter(Rec.rec1,'=%1',Rec.rec1::test);
IF Rec.FindSet
Repeat
IF ??????????
Until Rec.next = 0;
Sort it and then compare the duration between each nearest; if result would be >1 day, then they aren't consecutive.
Store in the a temporary date table and sort it by Date and compare it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (