Interesting. Had not heard of. As you say, "price is quite high for the functionality it's actually providing" but I'd be very interested to hear from anyone who's used the tool. Thanks, Wendy

Great question. Interested to see what others are using. Personally, I use SSMS because it's familiar and on my desktop anyway. My other option is Notepad++. Wendy

Hi Stephanie, if one of the case statement results is null then the result of the subtraction will be null. Have you looked at the results of both case statements as individual columns first so you can see what values they are returning? Wendy

Sounds like you have a working solution but, for future reference, be careful because timestampadd(sql_tsi_month,-30,current_date) will subtract 30 months (not 30 days or 1 month as you are intending.)

Thank you for sharing this information on this forum! It was on my to-do list to figure out how/why/when this was happening. Now I have an answer before I even asked the question! Wendy

Will do...thanks! Wendy

We have not experienced this but I appreciate you sharing this type of information. Often it's very helpful to know what other cloud clients are experiencing. Thanks, Wendy