Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
I have a in-DB Connection that has a start date and end date in the data. I need to be able to select a date from the date interface tool and return only rows that are between the start and end dates.
I was going to pull my data in, and then do the filtering one step at a time, but I'm struggling getting my date to convert to the previous Sunday with a Formula In-DB tool. My guess is there is an easier way to do this. Please help.
Solved! Go to Solution.
Hi JoePrespare,
Change the 'replace a specific string' to include only the date i.e 2019-08-07 .
This is the ex reading Teradata view .
