I use in Automation Studio, an SQL query using functions like dateAdd() and Datediff(). Since yesterday, this activity is errored with this message : " An error occured while checking the query syntax. Errors: The data types and time are incompatible in the add operator."
I didn't change this SQL activity since last october and it was running correctly almost every day.
Did I miss something in the releases?
here an example of my activity in SQL
Select dateadd(minute,dum.ID-1,cast(dateadd(day,dumday.ID-1,cast([Date Debut Campagne] as date)) as date) + cast([Heure Debut Campagne] + ':' + [Minute Debut Campagne] as time)) as currentDate, dateAdd(minute,dum.ID-1,cast([Heure Debut Campagne] + ':' + [Minute Debut Campagne] as time)) as [CalcHour], [Code Campagne SMS] as CodeCampagneSMS, case [Concatenee] when 1 then [Nombre SMS - Minute] *2 else [Nombre SMS - Minute] end as NBSMSMinute,Frequence from [Campagne] as B1