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
-
@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!**
4 -
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' ENDReturns the number of days between two dates from datetime values.
DATEDIFF(CURRENT_DATE(), 'lastmoddate')**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Thanks.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 179 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive