Click here to Skip to main content
15,071,262 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all , i had a requirement where i need to show the share price for the time interval the share traded in the market ,the time has to be my horizontal axis and i have to plot the share price between the start time and end time ,some shares has a time interval with one day and some shares has time interval for 4hrs and some shares have more than one day , what i want to do here is if the trade date is the same say like

in time 4/15/2011 9:00:05
out time 4/15/2011 14:05:02

i have to show the horizontal axis label for every hour (i have data for everyhour),if the trade has more than one day i have to show the horizontal axis label for every 3 hour interval, if trade time more than 3days i have to show the labels in day basis with 12:00 pm as time is it possible to acieve , i know i can do it by DATEDIFF() but i never used it and also tried google no luck can some one please help me out thanks .
Updated 18-Apr-11 10:49am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900