Hello Team
We have a requirement like get the next thursday date based on the current Date in GI. Tried in the SQL like below and it is working fine, Can you please provide Equivalent syntax in GI.
DECLARE in SQL @GivenDate DATE = '2024-05-15';
SELECT DATEADD(DAY, (4 - DATEPART(WEEKDAY, @GivenDate) + 7) % 7, @GivenDate) AS NextThursday;
Could someone please help on this.
Thank you.