Issue with dates in ETL

r4geqwit
r4geqwit Member
in Magic 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

Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    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 to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MarkSnodgrass
    MarkSnodgrass Coach

    @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 to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • r4geqwit
    r4geqwit Member

    Thanks so much @MarkSnodgrass ! We will try your workaround and report the bug, thanks again!

Categories