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

3 Replies

  • 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

  • lcanchila's avatar
    lcanchila
    Regular Visitor
    9 years ago

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

  • lcanchila's avatar
    lcanchila
    Regular Visitor
    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