we need SQL which gives Friday of running week with below conditions
If we run SQL on Monday and Tuesday of a week, SQL should return previous week Friday.
If we run SQL on Wednesday, Thursday and Friday ,SQL should return current week Friday.
example
If we run on 11th and 12 of January SQL should give 8th January
if we run on 13th, 14th and 15th of January, should give 13th January
Thanks in advance
Karthick