I have a set of data which has some dates of the week, I need to extract the next Friday date from the data and if the date is already on Friday then print the same date. I have tried multiple sources but one or the other error comes. I need to output on snowflake.
if date is 30-04-2024 then the output I need is 03-05-2024 (which is the next friday) and if the date is already 03-05-2024 then return the same date ( as it is already on friday)
New contributor
Rohit Bansal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.