DATEADD ERROR SYNTAX

[lcanchila]

Hi,

I'm trying create a calculate column to get a date subtracting 1 month, but I get a syntax error on MONTH. I don't know the reason.

See the function

Thanks

[lcanchila · Accepted solution]

I found the cause of error. It's for regional language setting. I have Spanish-Colombia. I changed it for Spanish-Mexico and work very well

[lcanchila]

Thanks for your answer Herbert, but I tried create a table with the same expression and I got the same error

[v-haibl-msft]

@lcanchila

DATEADD will return a table containing a single column of date values. You cannot create a column with a table expression.

Best Regards,

Herbert