Calculated Column using Current Date

JenHarrison

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.

RobSomers

@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.

MarkSnodgrass

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')

JenHarrison

Thanks.