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
pbeye's avatar
pbeye
Resolver II
7 years ago

I don't see "2015-08-16" in your formula, but I see "28-06-2015". Maybe that's the one causing the issue? Actually, when I test it out on my desktop both of those work for me. I'm using the July 2019 version.

 

Maybe try adjusting it to match the other dates formats to see if that works.

  • 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