Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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
Send me the error ...
Hey Alex,
i got the answer...
thanks a lot