... the .addDay(), check none of these are a Sunday, and move the next few days along:
thisDate = '2021-10-30';
v_Today = thisDate;
v_Tomorrow = v_Today.addDay(1);
v_NextDay = v_Today.addDay(2);
if(v_Today.getDayOfWeek()==1)
{
v_Today ...
... r_Staff in l_Staff
{
if(!isnull(r_Staff.get("id")))
{
v_StaffName = r_Staff.get("name");
}
}
Get the Available slots:
//
// get available slots
r_AvailableSlots = zoho.bookings.getAvailableSlots(v_ServiceID,v_StaffID,v_ThisDate.toString("dd-MM-yyyy"),"joels_connector");
l_AvailableSlot ...
... environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me.
What I want:
ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday ...
... on default settings).
Additional
-- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work)
(DT_DATE)(SUBSTRING(This_Date,1,2) + "/" + SUBSTRING(This_Date,4,2) ...
Situation:
I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...
... as an example, the equation that's happening is:
$thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));
$this_time_from1 = date("H:i", strtotime($sub_row['TimeFromSession']));
$this_time_to1 ...
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.