Created By: Luke Sims
Created Date: 23 September 2024
Specification Delivered By: Bradley Stafford, McKenzie Ajdukovich
Due to salesforce locale rules, Salesforce has determined that the beginning of the working week in the USA is Sunday… RedDoor however deem the beginning of the working week to be Monday and needed this to be reflected in their DSR report.
BookNow has created 2 custom formula fields.
| Feild Name | Object | Description |
|---|---|---|
| Week Number (P&L) | Booking Product | Calculates the week number from the beginning of the calendar year using P&L date from the booking product record and week beginning as Monday. And returns an integer between 1 - 52 |
| This Week (P&L) | Booking Product | Calculates the week number for today and returns True for any Booking Product record that match todays week number. So when used in a report filter, if “this week” = True, the records on display will be any that have a P&L date in this week (Starting Monday and ending Sunday). |