Home / Q&A / How to search for a range of dates based on a text value - Interpolation variable
You can translate the question and the replies:

How to search for a range of dates based on a text value - Interpolation variable

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. ``` select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ``` I am investigating ways to parse for specific users and dates across a range of dates. The "backupdate" variable is a text value since it is part of the file name. Is there any easy way to search for a range for dates? I tried to localdate funciton, but that is causing an error. I can do a IN statement like this but sometimes there are 100 files we need to check. ``` select wwid, name, status from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate in ('09-01-2021', '10-01-2020') and wwid = 12345 ``` any thoughts or suggestions?
Interpolation Variables AWS S3
user
09-09-2021 08:53:41 -0400

6 Answers

Hi, When you need access to files that use a date-based naming convention (as is typical in log files), use the [^DateRange interpolation function](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#paths-using-date-ranges) to consider only the files between a given start date and a given end date. For this, the name of the files follows the pattern application_log_<year>-<month>-<date>.csv (e.g. application_log_2014-11-19.csv). Hope this helps!
Denodo Team
13-09-2021 15:07:20 -0400
I got this working but there are certain files that don't exist in a range. I cannot find where you set the ignore route errors to "true" in either the source or the view. can you advise where this is located in version 8.0?
user
16-09-2021 09:18:36 -0400
Hi, You can configure this option to [ignore route errors](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#delimited-file-sources) under the connection tab of source in the Denodo Platform. It is a checkbox. Hope this helps!
Denodo Team
24-09-2021 12:46:56 -0400
Also is there a way to get the filenames to show up as a field in the results?
user
27-09-2021 07:31:38 -0400
Another issue I am uncovering, is in addition to not being abe to get the actual filename where the source info came from based on the filter I am only getting one row of results when I know I put a range that should be pulling in like 100 plus files.
user
27-09-2021 10:16:52 -0400
Hi, I suggest that you download "FileSystem Custom Wrapper” from Denodo Connects which helps to retrieve filename information through local and network folders. A response to a simlar Q&A can be found at this [link](https://community.denodo.com/answers/question/details?questionId=9060g0000004EgmAAE&title=CSV+Filename+Column). Hope this helps!
Denodo Team
04-10-2021 11:47:56 -0400
You must sign in to add an answer. If you do not have an account, you can register here