Datediff: Total Noobie question

user059525
user059525 Member
in Magic ETL

Hello all, I am non-technical, non-SQL speaker trying to figure out DATEDIFF.

 

My problem

1. In Domo, I have a date that looks like this:10/17/2019 11:06:45 AM (this is a 'date' field in my table)

2. I'd like to add a calculated field that counts how many day from "today" it is.

 

Can someone send me the Datediff statement I need?

 

 

Best,

PR

Best Answer

  • Godiepi
    Godiepi Coach
    Answer ✓

    Here it is 

     

     Datediff( Date(`yourdatefmield`) , Current_Date())

    or 

     Datediff( Current_Date() , Date(`yourdatefmield`))

    note: you might or might not have to specify Date for your date/time field

    thats why I usually prefer to do this:  Date(`yourdatefield`). , but that is just me

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Godiepi
    Godiepi Coach
    Answer ✓

    Here it is 

     

     Datediff( Date(`yourdatefmield`) , Current_Date())

    or 

     Datediff( Current_Date() , Date(`yourdatefmield`))

    note: you might or might not have to specify Date for your date/time field

    thats why I usually prefer to do this:  Date(`yourdatefield`). , but that is just me

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • user059525
    user059525 Member

    HUGE thanks. Worked perfectly.

  • mmisky87
    mmisky87 Member

    @Godiepi Rehashing an old thread, but wanted to let you know this helped me solve what appears to be such a simple problem 😁

Categories