1 Reply Latest reply on Dec 3, 2012 2:56 PM by philmodjunk

    Script to print between two dates

    mnrk

      Title

      Script to print between two dates

      Post

           Hi Phil & Everyone,

            

           I am looking for a script that will search between two dates and then print the records off. For example:

           I want the script to locate the dates and any between, ie, 01/01/2012 TO 01/02/2012 and then print the records that have a date within that calculation. Any chance anyone can give me some tips on how to achieve this?

            

           Many Thanks

           Mike

        • 1. Re: Script to print between two dates
          philmodjunk

               Perform a find for those records using date criteria with the range format:

               01/01/2012 ... 01/02/2012

               If you want, you can define two global date field to use for entering these two dates, then a script similar to this can find your records:

               Enter Find Mode []
               Set Field [YourTable::YourDateField ; Globals::gDate1 & "..." & Globals::gDate2]
               Set Error Capture [on]
               Perform Find[]
               Sort [Restore ; no dialog]
               Print