... (eg. "Wednesday9March"), which yields the following:
Then I get rid of the label with the following CSS:
label.zc-Calendar_Day_Select-label
Then get rid of the round circles for radio inputs ...
... 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();
...
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 ...
... column) and the days of the week along the top.
Why?
The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday).
How?
See the following screenshot ...
... StaffActivities s
WHERE WEEKDAY(s.DateTimeCreated)=2
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) AS 'Wednesday',
(
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) ...
... my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46:
This Week:
-- Start Date (US format - mm/dd/yyyy)
=DateAdd("d", ...
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.