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. ...
... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...
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 ...
... to the width of the word "Academic".
What I have:
Academic Week Monday Tuesday Wednesday Thursday Friday
---------------- ----------- ----------- ----------- ----------- -----------
1 ...
'Twas a Friday morn when we set sail
And our ship not far from land,
We there did espy a fair pretty maid,
With a comb and a glass in her hand,
Her hand, her hand,
With a comb and a glass in ...
... StaffActivities s
WHERE WEEKDAY(s.DateTimeCreated)=4
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) AS 'Friday',
(
SELECT ...
... 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.