Calendar Question

[#1]

I have an application that uses a Master calendar. My company ran an early month end on Friday (6/26). That means that all transactions from 6/27 through 6/30 will have an Accounting Date of July. Any ideas on how I can incorporate this into my Master Calendar which is based on Today's date without disturbing the Calendar functions already created?

[prieper]

Hi,

why not splitting into two fields: one with transaction-date, the other one with accounting-date or -month and then link your Master-calendar to one of them

HTH

Peter

[Anonymous]

I recommend to add a field "Accounting Month" to the master calendar, and define by the last Friday of the calendar month. Foe example:

JOIN (Calendar) LOAD DISTINCT
 MonthYear,
 max(DateID) as LastFriday
RESIDENT Calendar
where Weekday=4
GROUP BY MonthYear;
//
JOIN (Calendar) LOAD DISTINCT
 DateID,
 date(monthstart(if(DateID<=LastFriday, DateID, DateID+7)),'MMM-YY') as AccountingMonth
RESIDENT Calendar;