Calculated Column using Current Date

JenHarrison
JenHarrison Member
in Beast Mode

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 Coach

    @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!**

  • MarkSnodgrass
    MarkSnodgrass Coach

    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.
  • JenHarrison
    JenHarrison Member

    Thanks.

Categories