Help with beast mode formula  "case when" with date ranges
Hello!
A little context about the use of this beast mode in the card:
 Looking at YOY data with same date ranges
 Date Ranges: 8/1110/10
Here is the formula I have created:
case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1 else
case when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1 else 0 end end
Seems simple? I believe I am missing "September" or 9 in my formula but when I do try and add it in, the formula is invalid. Any help would be greatly appreciated! Thank you  Carly 🙂
Answers

@cbreen You'll want to modify it to the following:
case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then (
case when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1 else 0) else 0 end
This will say if the date is after 8/11 then look at if it's before 10/10 and if it is then 1 else 0, but if it's before 8/11 then also 0. Since you're wanting to evaluate the second condition only if the date is after 8/11, then you need to nest the second condition in parantheses.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 
Hi @cbreen, a couple edits to your formula:
 When you have multiple conditions you need to check, you can simply contain them with a single CASE...END. Instead of repeating "CASE", you can specify each new condition with WHEN
 You are correct that your current formula does not account for September. You can add this as an additional condition
Try something like this:
case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1 when month(`date_purchased`) = 9 then 1 when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1 else 0 end
3 
Thank you both @MichelleH & @RobSomers! Both explanations are great and help me understand how these formulas work  will try both in my cards. I appreciate the help! 🙂
0
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 297 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 614 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 729 Beast Mode
 53 App Studio
 40 Variables
 678 Automate
 173 Apps
 451 APIs & Domo Developer
 46 Workflows
 8 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 32 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive