... dates
l_AppointmentDates = List();
//
// initialize Start Date
v_GivenDate = '2022-07-21';
//
// setup list to loop through (= number of days)
l_NumberOfDays = ;
//
// start with first date to ...
... can book longer than a month):
// set criteria to search for clashing annual leave dates (pre/post 1 month check)
l_SearchCriterias = List();
m_SearchCriteria = Map();
m_SearchCriteria.put("searchField","From");
m_SearchCriteria.put("searchOperator","After");
m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy"));
l_SearchCriterias.add(m_SearchCriteria);
m_SearchCriteria ...
... November, 2018
Method #6:
The previous methods are inconsistent as it depends on the date format of the system. Instead (update 2021), I now use the following:
v_GivenDate = '2021-09-21';
m_Ordinals ...
... opposite, where the week starts on the previous Saturday and ends on the last working day of the week.
The Solution
Where "givenDate" is the given date you have to calculate the last working day ...
... for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule.
Problem
Consider the following query:
SELECT
rb.[GivenDate]
, rb.[DateStart]
...
... below... hopefully it will be quicker next time now that I noted it all down.
The SQL Script:
DECLARE
@StartTime datetime,
@EndTime datetime,
@GivenDate datetime;
SET DATEFORMAT dmy;
SET ...
... the given month (where "Gainsboro" is a type of light grey):
=IIf(Month(First(Fields!Date.Value))=Month(Parameters!GivenDate.Value), "Black", "Gainsboro")
Right-click on the Date textbox and select ...
... that will be submitted (GivenDate and GivenCampus). Consider the following script:
-- ===============================================================================
-- Description: Gets the room ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.