Using DateDiff and Current_date Functions with Syntax error

Options
AlexAppiah
AlexAppiah Member
edited April 30 in Beast Mode

I am new to Domo and want to know where am getting it wrong with this.

DATEDIFF(CURRENT_DATE(),'ShipDate') AS DaysTillDue

I am trying to calculate number days until shippment is due

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    edited April 30 Answer ✓
    Options

    It would help to know more about where you are entering this formula.

    The DATEDIFF(…) part should work as a Beast Mode or a Magic ETL formula, you don't need the "AS DaysTillDue" part in the code since you can enter "DaysTIillDue" as the column name.

    Also, make sure the ShipDate has two tick marks around it, not single quotes.

Answers

  • Sean_Tully
    Sean_Tully Contributor
    edited April 30 Answer ✓
    Options

    It would help to know more about where you are entering this formula.

    The DATEDIFF(…) part should work as a Beast Mode or a Magic ETL formula, you don't need the "AS DaysTillDue" part in the code since you can enter "DaysTIillDue" as the column name.

    Also, make sure the ShipDate has two tick marks around it, not single quotes.

  • AlexAppiah
    Options

    using the Beast Mode , Yes I think it did not like the Alias. Issue resolved.Thanks