08-31-2018 12:54 PM
I'm looking for assistance with adding a filter to the time source auth source. I'm looking for a filter to return the date of the next Monday.
If a user connects on a Monday, the time source filter would return the date of the following Monday. If the same user next connects on a Wednesday, the time source filter would still return the date of the following Monday.
Any help in generating the SQL syntax to place in the filter will be appreciated.
Solved! Go to Solution.
09-10-2018 11:00 AM - edited 09-10-2018 11:02 AM
If anyone was interested in the solution for their own environment, here's what I received from TAC.
select date_trunc('day', localtimestamp(0) + interval '1 day' * (select 8 - extract(isodow from date_trunc('hour', localtimestamp(0))) as temp)) as next_monday