Counting specific days \ day types between 2 dates.
A user asked it was possible to count the number of working (weekdays) between 2 dates. They had considered the function Datediff() within an expression but realised this simply counts the total number of days between 2 dates.
Our suggestion was to make use of the SelectedDays() expression function.
This takes 3 parameters:
1 First Date
2 Second Date
3 The 7 digit string of bits representing the days Monday to Sunday, in that order. So, "1111111" would be every day and "1111100" would just be weekdays and "0000011" would be just weekends.
As an example, this would return the number of weekdays between these two dates:
SelectedDays(20240708,20241208,"1111100")
This example below would give you the number of Mondays:
SelectedDays(20240708,20240720,"1000000")
The user concerned was using date variables rather than date literals but the expression would still give the required result, using the pattern of "1111100"
.
e.g.in the Apteco training Holidays system using the first and last booking dates for a person:
So 13 weekdays between the first booking 01/02/2023 and second 19/02/23.
Related Articles
Issue with date ranges in selections reverting to "Earliest to Latest" on Q1 2024 release.
Several users reported an issue that when creating selections within FastStats which included a date variable and contained a selection using a Date Range,. They found that after making changes to the other parts of the selection and subsequently ...Import a list of dates and URNs and run a selection to find the date in the system with the same URN and previous to the one in the list.
A client asked us for a method of importing a list of URNS and Dates, into an existing FastStats system, and then to suggest a method to compare the imported date to other dates for the same URN in order to then provide the previous date attached to ...Expression Index Geo Nearest
An issue arose when a selection was created from an Geo Nearest Expression using an index. The problem was that the place was not corresponding to the coordinates on the map Visualisation. E.g. When choosing Warwick in the list on the selection and ...Combining Table Results in Orbit using a CubeLookup Expression
Sometimes it is useful to be able to get results from a Table in Orbit and use them in another Table. Within Orbit, it isn't currently possible to refer to results in one tile within another one. However, we can use a combination of some powerful ...PS Unable to find the versioned file
In Q3 23 we changed the default stance on versioned selections to error if it can not find the latest version available for the selection that is being used in the Campaign. To revert this back to use versioned files in the db, please set this in the ...