Using DateDiff and Current_date Functions with Syntax error

AlexAppiah
AlexAppiah Member
edited April 2024 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 2024 Answer ✓

    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 2024 Answer ✓

    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
    AlexAppiah Member

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

Categories