Visit same client within 30 days
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I'm trying to find when we have revisited a client within 30 (considered a guarantee visit).
I managed to find all the jobs that have been revisited more than once but how do I compare the dates and compare it to a 30 day difference?
To make it more understandable, in the screenshot, i:base number would be the clients code.
As you can see where I highlighted the fields the same client code would have 2 visits within a 30 day difference and would have to be classed separate as that would bring a cost to the company.
Any ideas are welcomed :)
Thank you all in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AlexGavri -- if you sort the data by 'i:base number' as well as date (ascending) then do a multi-row formula (grouping on 'i:base number' so it doesnt compare across groups. Then create a calculation in the multi-row along the lines of this: if DateTimeDiff([Date],Row-1[Date],"days")<30 then 'Flag' else 'No Flag' endif
My syntax might be off as I am writing it off the top of my head... doublecheck the order of the dates in the formula. Might have to flip those, but basically it should be pretty straight forward
I dont have time to mock it up in a YXMD file, but hopefully this is helpful... :)
