Forum Discussion

dirkjs's avatar
dirkjs
Frequent Visitor
7 years ago

Incorrect syntax for DATETIME

I get an incorrect syntax error for the DATETIME strings in the example below: CustomFiscalPeriods = DATATABLE ( "Fiscal YearNumber", INTEGER, "FirstDayOfYear", DATETIME, "LastDayOfYear", DATE...
Need Help
dirkjs's avatar
dirkjs
Frequent Visitor
7 years ago

Thanks for your response, but, both notations "28-06-2015" as "2015-06-28" do not work!

pbeye's avatar
pbeye
Resolver II
7 years ago

Can you post a screen shot of what you see? It workes fine for me which is weird. You're trying to create a new table and not a column, correct?

  • dirkjs's avatar
    dirkjs
    Frequent Visitor
    7 years ago

    That is true. I try to create a table with 3 columns.

    Incorrect Syntax for DATETIME

    • dirkjs's avatar
      dirkjs
      Frequent Visitor
      7 years ago

      This is something for Power BI Development Team. I tried to comment the second field and I got the following strange result!Second field as a comment.

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        hi, dirkjs 

        Could you try my sample pbix to check it if works well.

         

        Best Regards,

        Lin