Date drives in-db connection

[JoePrespare]

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.

[benakesh · Accepted 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 .