Convert to weekend

smilingjohn — Mon, 13 Sep 2021 08:04:10 GMT

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

Re: Convert to weekend

Kushal_Chawda — Mon, 13 Sep 2021 08:54:22 GMT

@smilingjohn your syntax is wrong

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

topic Re: Convert to weekend in App Development

Convert to weekend

Re: Convert to weekend