Calculated Column using Current Date

Hi There,

I am trying to use a similar calculated column I had in Tablau that I use to filter out some data from my dashboards. Basically, I want to look to see if there has been a 6-day lapse since today and a ‘credit release date’. I am getting a syntax error with the statement I am using below. Any ideas?

case when DAY(CURRENT_DATE()-[Credit Release Date]<6 THEN 'Recent' ELSE 'No' END

Thanks.

Comments

  • RobSomers
    RobSomers Contributor

    @JenHarrison It looks like your missing a ) after CURRENT_DATE which is resulting in the syntax error. Though you will probably want to use the DATEDIFF() function instead as in your current beastmode it's just subtracting the day of the month so you might run into situations where it results in a number greater than 6 but it is actually within 6 days. DATEDIFF() will give you the number of days between two dates.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • I would use the DateDiff function to do this. Something like this:

    case when DATEDIFF(CURRENT_DATE(),Credit Release Date) <6 THEN 'Recent' ELSE 'No' END
    

    Returns the number of days between two dates from datetime values.
    DATEDIFF(CURRENT_DATE(), 'lastmoddate')

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Thanks.