Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys,
I need to generate Dates.A list Box has years in it.
Now based on the year selection I need to generate dates.Something like this..
If I select 2009 then the dates I generate will be like
1st Jan 2009,8 Jan 2009,15 Jan 2009,........31st Dec 2009.
These dates should be like dimensions in a bubble graph.
No idea how to do do this.Please let me know if anybody has an idea.
Regards
Navin.G
Get a copy of the QV Cookbook from
http://robwunderlich.com/downloads/
Take a look at the example "Generate date (calendar) table.". That includes some typical patterns for generating dates. Dates are an integer. Incrementing a date by seven days is done by adding 7. There are also functions like WeekStart() that will identify the first day of the week.
-Rob
Hi Guys,
I will let you know what my actual requirement is...
I have columns like Job Date and PM Interval
Now I need to generate dates like 1st Jan 2009,10th Jan 2009,20th Jan 2009,....31st Dec 2009.
Dates have to be generated at an interval of 10 Days.I can do this date generation now.
I need to show a bubble chart which has these above generated dates in the x-axis and Pm Interval
in the y-axis.
Now, Suppose we have the foll data of Job Date and PM Interval
Job Date PmInterval
2-Jan-2009 30
4-Jan-2009 40
Now there will be two bubbles between 1st Jan 2009 and 10th Jan 2009 and at intersection point
of PMInterval 30 and 40.
Please guide me with this.
Regards
Navin.G
Hi Guys,
I will let you know what my actual requirement is...
I have columns like Job Date and PM Interval
Now I need to generate dates like 1st Jan 2009,10th Jan 2009,20th Jan 2009,....31st Dec 2009.
Dates have to be generated at an interval of 10 Days.I can do this date generation now.
I need to show a bubble chart which has these above generated dates in the x-axis and Pm Interval
in the y-axis.
Now, Suppose we have the foll data of Job Date and PM Interval
Job Date PmInterval
2-Jan-2009 30
4-Jan-2009 40
Now there will be two bubbles between 1st Jan 2009 and 10th Jan 2009 and at intersection point
of PMInterval 30 and 40.
Please guide me with this.Let me know if you have any issues.
Regards
Navin.G
Hi,
Please see the attached sample can generate every 10th day in a year.
Cheers.