Jan,
Here's how ...
Use the IDWK function to exclude the 6th and 7th (Saturday and
Sunday) day of the Week.
-- IDWK returns the day of the week where Monday is 1.
-- Example 01
SELECT * FROM tablename WHERE (IDWK(datecolumn)) NOT IN (6,7)
-- Example 02
SELECT * FROM tablename WHERE (IDWK(datetimecolumn)) NOT IN (6,7)
That's all there is to it!
Have fun.
Very Best R:egards,
Razzak
At 07:15 AM 3/16/2021, jan johansen wrote:
Group,
Anyone got a good date algorithm that ignores weekends? Or in other
words, only counts workdays?
Jan
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/0Lm2Pn-1lvSWt3yqH-00Zixe%40mrelay.perfora.net.
