5 Replies Latest reply: Jun 28, 2011 8:37 PM by Johannes Sunden RSS

    Dates

      Another novice question...

       

      I have a spreadsheet with lots of data against DateRaised, so for example

       

      01/01/11 RTA

      02/01/11 Injury

      03/01/11 Injury

      .

      28/05/11 RTA

      29/05/11 RTA

      30/05/11 RTA

      31/05/11 Injury

       

      How do I create a list box with Jan, Feb.......Dec, so users can select a month and see the totals

      Do I need to do something in the load script? I've been searching other discussions and can't quite work out what I need to do.

       

      Thanks

      M

        • Dates
          Leonard Short

          Is the data above all in a single field? or multiple?

           

          Either way you just need to add a couple lines to your load script.

           

          Load DateRaised,

               month(DateRaised) as month,

               year(DateRaised) as year,

           

           

          If the data is in a single field then do

           

          Load DateRaised,

               month(left(DateRaised,8) as month,

          • Dates
            Johannes Sunden

            Hi Melanie,

             

            I assume you have a load statement in the script like:

            Load

                 DateRaised,

                 Type

            From xxxx;

             

            You can create a new Month field there by doing something like this:

            Month(Date#(DateRaised, 'DD/MM/YY')) as Month

             

            The Date#() function is to properly identify the DateRaised as a date value so that you can use Month() to extract the month.