Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I was handling the task as following scenario,
Please suggest your ideas.
Thanks & Regards,
Ashok Ravichandran
Hi Can you give Yes or No to below questions?
Do you want to refresh 4 tabs on every Monday?
Do you want to refresh 4 tabs if first day is Monday?
Do you want to SKIP 4 tabs to refresh if Day is not Monday?
Do you want to SKIP 4 tabs to refresh if Day is not Monday on first day of the Month?
Hi Try like this:
SET vMonthStartDay=WeekDay(Monthstart(today()));
SET vWeekStartDay=WeekDay(Weekstart(today()));
If $(vMonthStartDay)='Mon' or $(vWeekStartDay)='Mon' THEN
Tab1:
Load * inline [
A,S
1,2
];
elseif ;
Hi Arjun, Thanks for your comments.
Do you want to refresh 4 tabs on every Monday? Yes
Do you want to refresh 4 tabs if first day is Monday? Yes
Do you want to SKIP 4 tabs to refresh if Day is not Monday? only one particular tab should get skiped. Eg: 3rd tab
Do you want to SKIP 4 tabs to refresh if Day is not Monday on first day of the Month? if month 1st day is Wednesday except 3rd tab every should get refreshed, but month first day is also Monday again every 4 tabs should get refreshed.
Looking forward to your comments!!
Hi Ashok,
Use this code in third tab. No need to change the code in other tabs.This will work all.
If ( $(vMonthStartDay)='Mon' or $(vWeekStartDay)='Mon' ) AND ( $(vMonthStartDay)='Wed' or $(vWeekStartDay)='Wed' ) THEN
Tab3:
Load * inline [
A,S
1,2
];
elseif ;
Thanks for you suggestion Arjun!!
Happy to help you.
Please Mark Correct Answer and close the thread.