Issue with dates in ETL
Hello everyone! So we use filters similar to this in Domo and noticed that for some reason all results are being returned. What is happening below is we apply a filter on the rule to only look at 'Y' results that should be only applications hired this year, but instead we receive everything. We are working through it on our end still but wanted to see if anyone else has noticed this odd behavior since turning into the new year? Perhaps a Domo issue?
CASE when `Application Latest Hired Date`>='1/1/2022' then 'Y' else 'N' END
Answers
-
I would double-check that your Application Latest Hired Date is being seen as a date field by Domo and not a text/string field. If it is not being viewed as a date field, the evaluation will be problematic.
**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.1 -
@r4geqwit I actually was able to recreate your issue in Magic ETL. This does seem like a bug that should reported to Domo Support. However, I was able to develop a workaround by wrapping a date function around both values and then it evaluated correctly. Like this:
CASE WHEN DATE(`datereported`) >= DATE('1/1/2022') THEN 'Y' ELSE 'N' END
I would suggest doing something like this your ETL as a temporary fix, but also letting support know of the bug.
**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 so much @MarkSnodgrass ! We will try your workaround and report the bug, thanks again!
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 469 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive