Generating Dates

[#1]

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

[rwunderlich]

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

[#3]

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

[#4]

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

[#5]

Hi,

Please see the attached sample can generate every 10th day in a year.

Cheers.