Date funciton - to be flexible in loading data

[#1]

load entity,

       Client

From

i am uploading data from above excel file on shared drive, but i need date to be flexible as each day the name of file will change to T-2 business date. Could anyone please help in letting me know the possible solution

[alexandros17 · Accepted solution]

Let myDate = text(num(day(today()),'00')) &  text(num(month(today()),'00')) & text(num(year(today()),'0000'))

Let myFile = ''

...

load

     ...

     ...

from $(myFile)

hope it helps

[#3]

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

[#4]

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

[#5]

thanks for prompt response.

but i am using

let myDate = text(if(left(weekday(today()-2),1)='S'.Date(Today()-4,'MMDDYYYY'),Date(Today()-2,'MMDDYYYY')));

as my excel file for today will be always 2 days old and i have to ignore weekends also.

but it gave a load error.

please advise

[alexandros17]

Send me the error ...

[#7]

Hey Alex,

i got the answer...

thanks a lot