I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function"
The file saved in my local directory as below
I am creating the connection. I am giving the right path as i have put the detail like below
File paht: Filepath/^DateRange("yyyy/MM/dd",@start_date,@end_date,"yyyyMMdd")
File name pattern: (.)\.log
now the problem is when i hit test connection it asked me to put start date and end date and i put in every format but it doesn't accept
Start Date: '20160101' or '2016-01-01' or '2016/01/01'
Start Date: '20160107' or '2016-01-07' or '2016/01/07'
i tried put the date in various format but didn't work. any idea what am i doing wrong?