... runs the following deluge script:
// only run if true
if(input.Copy_Monday_to_the_Other_Days)
{
// init
c_Tuesday = Collection();
c_Wednesday = Collection();
c_Thursday = Collection();
...
... yields "3 days ago" (it's Thursday)
$v_Str = getTimeAgo('first day of this month');
// yields "15 days ago" (it's the 16th)
The same PHP function as above but somewhat minimized
function getTimeAgo($p){
...
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 ...
... and note the dates for Monday, Tuesday, Wednesday, and Thursday:
Note how amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that ...
... - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) AS 'Thursday',
(
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed
FROM ...
... 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) ...
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.