how to do date difference data between event date and current date - X days with lesser execution time.

[chandanasa]

Dear community,

@ParthaSarathy  

In the database there is a packaged date attribute column that is in the string format. we need to fetch list of rows between from - 230 to - 210 days (for example: from 29-02-2024 to 21-03-2024) to current date. we have a solution but in our database millions of data. It is taking around 3 mints to retrieve the data from the query activity,  Is there any possibilities to reduce the query execution time?

It would be grate if I get the solution.

Regards

Satya

[_Manoj_Kumar_ · Accepted solution]

Hello @chandanasa 

The way you are doing it is correct. The query is slow because of data type conversion.