8 Replies Latest reply: May 15, 2014 10:10 AM by Data Kruncher RSS

    Date Extraction Issue

    Bradl Vogl

      I want to calculate on time delivery from a report.

      One field is the "shipped date" field (formatted as date)

      The other field "Due Date" I had to extract from a character formatted field.

      I used Substr(,1,8)[/SIZE]

      to extract the date from a description field.

      I now have a "Due Date" field, although, it is formatted as a character field.

      As it being a calculated field, it will not allow a date format change.

      Can I extract the date from the "description" (character formatted) field and have a date formatted field as the result?

       

      Once both are in date format I need to calculate the difference of due and shipped dates in workdays (weekdays)

       

      I appreciate any input.

       

      Thanks,

       

      Brad Vogl

        • Date Extraction Issue
          Data Kruncher

          How does the date appear Brad? What is the format/presentation used?

            • Date Extraction Issue
              Bradl Vogl

              The description field is 30 characters long.

              The first 8 characters are the ( *//* ) date.

               

               

              [SIZE=2]Customer[/SIZE][/FONT][FONT=Tahoma][SIZE=2]Item[/SIZE][/FONT][FONT=Tahoma][SIZE=2]Qty[/SIZE][/FONT][FONT=Tahoma][SIZE=2]Resale[/SIZE][/FONT][FONT=Tahoma][SIZE=2]Due Date[/SIZE][/FONT][FONT=Tahoma][SIZE=2]Shipped Date[/SIZE][/FONT][FONT=Tahoma][SIZE=2]PO #[/SIZE][/FONT][FONT=Tahoma][SIZE=2]DESCRIPTION[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]100[/SIZE][/FONT][FONT=Tahoma][SIZE=2]52.51[/SIZE][/FONT][FONT=Tahoma][SIZE=2]02/04/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]2/17/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200024713[/SIZE][/FONT][FONT=Tahoma][SIZE=2]02/04/11 B171952 LN 1[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908003[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6[/SIZE][/FONT][FONT=Tahoma][SIZE=2]60.05[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/25/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]2/7/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200025068[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/25/11 B172893 LN 9[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908003[/SIZE][/FONT][FONT=Tahoma][SIZE=2]7[/SIZE][/FONT][FONT=Tahoma][SIZE=2]60.05[/SIZE][/FONT][FONT=Tahoma][SIZE=2]02/22/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]2/21/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200025981[/SIZE][/FONT][FONT=Tahoma][SIZE=2]02/22/11 B173914 LN 2[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908201[/SIZE][/FONT][FONT=Tahoma][SIZE=2]20[/SIZE][/FONT][FONT=Tahoma][SIZE=2]130.16[/SIZE][/FONT][FONT=Tahoma][SIZE=2]12/10/10[/SIZE][/FONT][FONT=Tahoma][SIZE=2]1/5/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200024124[/SIZE][/FONT][FONT=Tahoma][SIZE=2]12/10/10 B171234 LN 6[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908201[/SIZE][/FONT][FONT=Tahoma][SIZE=2]16[/SIZE][/FONT][FONT=Tahoma][SIZE=2]130.16[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/17/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]1/31/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200024713[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/17/11 B171953 LN 2[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908601[/SIZE][/FONT][FONT=Tahoma][SIZE=2]50[/SIZE][/FONT][FONT=Tahoma][SIZE=2]120.94[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/10/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]1/4/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200024450[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/10/11 B171680 LN 2[/SIZE][/FONT][FONT=Tahoma][SIZE=2]ANSA0001[/SIZE][/FONT][FONT=Tahoma][SIZE=2]N16908601[/SIZE][/FONT][FONT=Tahoma][SIZE=2]25[/SIZE][/FONT][FONT=Tahoma][SIZE=2]120.94[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/17/11[/SIZE][/FONT][FONT=Tahoma][SIZE=2]2/1/2011[/SIZE][/FONT][FONT=Tahoma][SIZE=2]6200024450[/SIZE][/FONT][FONT=Tahoma][SIZE=2]01/17/11 B171681 LN 3[/SIZE][/FONT]