Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@smilingjohn your syntax is wrong
Date(WeekEnd(MinDate + IterNo() -1),'MMM/DD/YY') as WeekEnd,
@smilingjohn your syntax is wrong
Date(WeekEnd(MinDate + IterNo() -1),'MMM/DD/YY') as WeekEnd,