Forum Discussion

lcanchila's avatar
lcanchila
Regular Visitor
9 years ago
Solved

DATEADD ERROR SYNTAX

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
Data Modeling
  • lcanchila's avatar
    lcanchila
    9 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

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