Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I would like to Display 3rd saturday in all months
Can anyone help me out of this.
Regards,
Kishore.
PFA.
May be this
If(WeekDay(tran_date) = 'Sat' and Day(tran_date) > 15 and Day(tran_date) < 21, 1) as Third_Saturday
May be this
If(WeekDay(tran_date) = 'Sat' and Day(tran_date) > 15 and Day(tran_date) < 21, 1) as Third_Saturday
Happy to say this worked Sunny