Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one file where i extract data from it with T-1 filter.But on monday I extract it with T-2 .As per user's requirement they do not include sundays data or any holidays data(eg.,Public holiday,Independance day,festivals).So currently I'm doing this process manually but I want to schedule this report.Please help me in this kind of scenario.Please find attached sample data.
Regards,
Rup
Dear Antonio,
Data should be come for 14th august.In india Today is 16th August and My user want to see only Working days data.On 15th august we have holiday.
Try this,
LOAD ID,USERNAME,
// DATE(DATE#(LEFT(Date,10),'YYYY-MM-DD'),'DD/MM/YYYY') AS DATE,
Date(Floor(Date)) as DATE,
Branch
FROM
SAMPLE.xlsx
(ooxml, embedded labels, table is Sheet1)
WHERE If(Text(WeekDay(Today(0)))='Mon' or Exists(HOLIDAYLIST,Today(0)-1),
Date(Floor(Date))=Date(Today(0)-2), //on monday
Date(Floor(Date))=Date(Today(0)-1)) //on week days
and Not Exists(HOLIDAYLIST,Date(Floor(Date)));