Wednesday, August 6, 2014

How to prepare on the rally racing day

Things to take 
  • Enough Pens of different colors
  • Enough Highlighters of different colors
  • Enough Pencils
  • Erasers
  • Stopwatch
  • Hardboard Files
  • Paper Clips

When you get the rally sheet
  1. If you have a back up crew divide the work you have among each other.
  2. Write down the mileage of the questions on the rally sheet. Count them on the rally sheet and the questions paper in order to make sure you won't miss writing down any question on the rally sheet.
  3. Highlight the questions in one chosen color, so your eye will catch it easily.
  4. Calculate time to spend on each leg and write it on the sheet. The speed (add 10% more to it), time to spend, and how many kms on that leg. Highlight them all in a different color.
  5. From the sheet that you prepared to get your meter readings, write down the meter readings on the rally sheet.

While you are on the rally
  1. Zero your odometer and the stopwatch on the starting point.
  2. Mark each step you have passed on the rally sheet.
  3. When you have an instruction that you don't know, read it again and again or search it online. It won't work for hunches and guesses.(Turn to left from TG40 light post)
  4. If the instruction says "Take the second exit", go to the junction and count each road cause you might never know of unnoticeable hidden roads.
  5. If your odo meter shows 10m instead of 100m, beware because marshals might have done the plotting the track from 100m odo meters.

Wednesday, June 26, 2013

Get Day of week in Sharepoint 2010 designer workflow

Get Day of week in SharePoint 2010 designer workflow


Hi everyone, 

In this article I'm going to show you how to get the day of a week as in Monday, Tuesday, etc.. in SharePoint workflow using SharePoint designer.
 

In SharePoint workflow there is NO inbuilt function or command to get the day according to the research i did. So what I did was get the date as a long date (ex : Friday, June 21, 2013 ) and got the day as a string  using sub-string function. 

Step 1 : Get the sub-string









Choose the last on because you will want to give the length.

Step 2 : Select the date where you want to get the day of the week in this case it's created date.

 select as mentioned above.

Step 3 : Set the starting index and the length of the word.
 
  •  please note that the starting index is "1" in this index not "0"
I wanted to check the date is a "Friday" so as in the above table I put 
"starting at 1 for 6 characters" and the Output comes to the "Variable:substring". (You can define a new variable to get the output)


Then use it anywhere you want.




References :

Note :
I tried to give the length of the string dynamically by getting the index number of the first comma (Friday, June 21, 2013) using IndexOf(string) method mentioned in the above reference url. But it doesn't work as I wanted it to so i gave the length statically.

If you find a away to get the length of a string dynamically or an easy way to find the day, please leave a comment. :)