Hi all,
I've been trying to convert the below code from sql server to run directly from excel vba. But unable to do so.
Update Legal Set Category = Case
when datediff(month,GETDATE(),[End date])>6 then 'Blue'
when datediff(month,GETDATE(),[End date])<6 and datediff(month,GETDATE(),[end...