how to load data in based on file date?

jim_chan — Wed, 24 Oct 2018 05:55:24 GMT

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

Re: how to load data in based on file date?

dplr-rn — Wed, 24 Oct 2018 19:00:45 GMT

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