- Last Active
I ended up doing the same thing. Sounds like WITH probably just isn't available in Domo then. Thanks for your input
Guess I'll try Domo Support then. Thanks for the input
The cancel link usually isn't there. I think it might only show up for magic ETL dataflows? Whereas most of the ones I use are MySQL dataflows.
Thanks, that's all really good info to know. I'll try calling the API directly and see if it turns out the same.
Yes, that did exactly what I needed, thanks. Apparently I didn't search through the date functions documentation thoroughly enough. For any future searchers, this is the exact line of code I used: STR_TO_DATE('1/31/2015', '%m/%d/%Y')
@kshah008not exactly, there is some additional transformation and formatting that require the use of a SQL dataflow, rather than a magic ETL. And in any case, I've found a way to get Domo to recognize "1/1/2015" as a date, but I'm wondering if there's an easier way to do it. It seems counterintuitive to me that if Domo…