Exclude Sunday between two dates

[marishnagendran]

Dear All,

I have a From Date and To_Date between this two dates i want to exclude Sunday in Front-end

Example:

From date it is in variable ('21-06-2020')

To date is (Today()-1)

Between this two dates i want to eliminate the 4 sunday dates(21-06-2020 starts in sunday,28-06-2020,05-07-2020,12-07-2020)

Need your help

[Kushal_Chawda]

What exactly do you want to do? Do you want to find working days between two Date?

[Saravanan_Desingh · Accepted solution]

You can use the flag to ignore the days.

tab1:
LOAD Date('6/21/20'+IterNo()-1) As TranDate,
	 WeekDay('6/21/20'+IterNo()-1) As TranDN,
	 If(WeekDay('6/21/20'+IterNo()-1)='Sun','Y') As SunFlag
AutoGenerate 1
While Date('6/21/20'+IterNo()-1)<=Today();