How can i grab the data between 2 dates from my updated_date field?

[svemurilv]

Hi ,
I am using Splunk DB Connect to take the database data in to Splunk.
In that data, i have a data field name as update_date
In my dashboard, i would like to search the data based on the update_date and should take the input date_time from the time_picker drop-down.

i want search all updated data between x-date to y-date. Or updated date =x-date should display all the data on that updated data.

My updated_date and _time (indexing times) are different. My updated_date is in _raw.

In search, I am taking different sources data using "left join"

thanks

[somesoni2 · Accepted solution]

Have a look at this.

https://answers.splunk.com/answers/390108/how-to-search-based-on-a-time-field-that-is-not-ti.html

[svemurilv]

Thanks @soni its working