4 Replies Latest reply on Jun 8, 2016 8:37 AM by cbishop01

    Text Variable "Date" question?

    cbishop01 Level 2

      how can i get my output and created date to look like my Modified date? The below is how it looks in the script now.  I just like the look of the Modification date string. If its not possible to make them look that way no big deal I'm just curious.

       

      Date Modified:    June 7, 2016 3:52 PM

      Date Output:    06/06/16

      Date Created:    06/06/16

        • 1. Re: Text Variable "Date" question?
          cbishop01 Level 2

          This is the code i'm using the R5 and 6 are exactly the same other than the different Cell Numbers.

          var cell3OfColumn2insertionPoint1 = myTable.columns[1].cells[3].insertionPoints[0];
          var R4 = cell3OfColumn2insertionPoint1.textVariableInstances.add(LocationOptions.AFTER, cell3OfColumn2insertionPoint1);
          R4.associatedTextVariable = doc.textVariables.itemByName("Modification Date"); 
          
          R5.associatedTextVariable = doc.textVariables.itemByName("Output Date");
          
          R6.associatedTextVariable = doc.textVariables.itemByName("Creation Date");
          
          • 2. Re: Text Variable "Date" question?
            vinothr Level 3

            You can use the Date class to get what you want but please note the following:

             

            var date = new Date();

            date.toDateString:                    Wed Jun 08 2016

            date.toLocaleDateString:         Wednesday, June 08 2016

            date.toLocaleString:                Wednesday, June 08 2016 08:25:58

            date.toGMTString:                   Wednesday, 08 Jun 2016 02:55:58 GMT

            date.toLocaleTimeString:        08:25:58

            date.toTimeString:                    08:25:58 GMT+0530

            date.toUTCString:                    Wednesday, 08 Jun 2016 02:55:58 GMT

            date.toString:                          Wed Jun 08 2016 08:25:58 GMT+0530

            date.getDate():                        8 (1 - 31)

            date.getMonth():                      5 (0-11)

            date.getFullYear():                  2016

            date.getTime():                      1465354558248

             

            You should choose between whether you want local or UTC/GMT time.

             

            Your function should look like:

             

            function getFormattedDateString() {
            var date = new Date();
            var month = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "July", "Aug", "Sep", "Oct", "Nov", "Dec"];
            
            // Handle zero prefix
            var formatDate = ("0" + date.getDate()).substr(-2);
            var formatHour = ("0" + date.getHours()).substr(-2);
            var formatMin = ("0" + date.getMinutes()).substr(-2);
            var formatSec = ("0" + date.getSeconds()).substr(-2);
            
            
            // Handle AM/PM time period
            var period = (date.getHours() < 12)?"AM":"PM";
            
            return month[date.getMonth()] +" " + formatDate + ", " + date.getFullYear() + " " + formatHour + ":" + formatMin + " " + period;
            }
            
            1 person found this helpful
            • 3. Re: Text Variable "Date" question?
              vinothr Level 3

              The above script function is to get custom format string from Date object.

               

              Another easy option is:

              In order to change format of Modification Date variable you can do below:

               

              Via Script

              var md = doc.textVariables.itemByName("Modification Date");
              md.variableOptions.format = "MMMM dd, yyyy hh:mm a";
              

               

              Via UI

              Go to Type->Text Variables -> Define

              Select Modification Date and click Edit button.

              In the Date Format, enter the following:

              MMMM dd, yyyy hh:mm a

               

              Now, all text variable instances of Modification Date will have your desired format.

              1 person found this helpful
              • 4. Re: Text Variable "Date" question?
                cbishop01 Level 2

                Both these are correct i wish i could mark correct for both.