Convert to weekend

[smilingjohn]

Hi All 

I am trying to implement the master calendar from below script . But I am not able to get the weekend from this script can soemeone please help me wiht this 

Calendar:
LOAD

Date(MinDate + IterNo() -1,'DD/MM/YYYY') as Date,
Date(MinDate + IterNo() -1,'YYYY') as Year,
Date(MinDate + IterNo() -1,'MM/YY') as Month,
Date(WeekEnd(MinDate + IterNo() -1,'MMM/DD/YY')) as WeekEnd,
//Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY')
Date(MinDate + IterNo() -1,'YY') & '_' & Num(Week(MinDate + IterNo() -1),'00') as Week

While
MinDate + IterNo() -1 <=MaxDate;

LOAD
min(Date) as MinDate,
max(Date) as MaxDate

Resident Transactional;

Thanks in Advance

[Kushal_Chawda · Accepted solution]

@smilingjohn  your syntax is wrong

Date(WeekEnd(MinDate + IterNo() -1),'MMM/DD/YY') as WeekEnd,