last 5 working days

[ali_hijazi]

got a table with a field named creation_date

I want to select the values of creation_date that are the last 5 working days available via a macro

Please advise

[datanibbler]

Hi Ali,

well, you can easily define a working day in your calendar (based on Weekday([date]))

=> Using the PEEK() or PREVIOUS() functions you can (in the script) look into the last 5 records and check whether those are the last 5 working days - if so, there is data for the last 5 working_days.

HTH

Best regards,

DataNibbler