... in a subform called "Mondays" then to click a button which copies it to the remaining working days.
How?
So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. ...
... few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on.
How?
We're going to get today's date, then use ...
What?
An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...
What?
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday").
Why?
If I use the toString() function to get the day, it only returns the first 3 letters ...
... do not account for days off (eg. Saturday / Sunday)
How?
Adapted from a forum topic: SQLTeam Forums
First of all, we want the rows to multiply based on the value of the column:
SELECT
...
... - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) AS 'Saturday',
(
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed
FROM ...
What?
Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. ...
... AS Day, '14/10/2011' AS Date, NULL, '23:59', NULL, NULL FROM [pretendDatabase].[pretendSchema].[pretendTable] WHERE [pretendField]='elephantastic'
UNION ALL
SELECT TOP 1 'Saturday' AS Day, '15/10/2011 ...
... WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay,
DATE(s.DateTimeCreated) ...
... in with a normal calendar date and returns an academic week number and the week commencing date.
Problem?
The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer ...
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.