how to load data in based on file date?

[jim_chan]

hi guys,

I have a problem here...

I want to load data in based on the file date.

For exmaple:

i have a transaction file which have a report_date field.

it has data in 18-oct-2018, 19-0ct-2018,20-10-2018.

Howerver, the file sent to me is daily - trx_sales_20102018. Client just want transaction for 20 oct 2018 only.

So how can i do that? make sure that the loading the data in based on the file date????

Rgds

Jim

[dplr-rn]

What do you mean based on file date?

if you mean file modified date you can get it like below

Let vSetDate=Date(Floor(FileTime('Dummy.xlsx'))); (floor is to remove timestamp)

and use a where clause on your load and this variable