5 Replies Latest reply on Oct 16, 2016 7:57 PM by philmodjunk

    Date format

    mcrostie

      Hi

       

      I am having problems with the way the date is format (US format not AUST) in the Comments field

       

      The particular line in the script is the following

       

      "Printed Label and Posted order at " & Get (CurrentTime ) & " on "  & GetAsText (Get ( CurrentDate ))”

       

      and it sets the format to US

       

      Am I missing something

       

      Thanks in Advance

       

      Michael

        • 1. Re: Date format
          user17152

          I'm not sure why the date is defaulting to US format, but you could handle it by using the Month(), Day(), and Year() functions to construct your own date:

           

          "Printed Label and Posted order at " & Get (CurrentTime ) & " on "  & Day ( Get ( CurrentDate ) & "/" & Month ( Get ( CurrentDate ) & "/" & Year ( Get ( CurrentDate ) )

           

          Maybe there's a setting somewhere that will make Get ( CurrentDate ) format the date the way you want, but my suggestion ensures that it will *always* be correctly formatted.

          • 2. Re: Date format
            philmodjunk

            What you are encountering is normally a function of your computer's locality setting and what you have selected in File Options in the data entry section of the text tab.

            • 3. Re: Date format
              mcrostie

              Hi  Phil

               

              The File Options Text Tab is set to "Always Use current system Settings"

               

              All other date fields are working correctly - I would have thought it would have been correct _ FM Bug perhaps?

               

              Regards

               

              Michael

              • 4. Re: Date format
                mcrostie

                Thanks U17152

                 

                I will use the workaround - Strange it is happening though

                 

                Regards

                 

                Michael

                • 5. Re: Date format
                  philmodjunk

                  There can be a difference here depending on the version--and possibly the version used to originally create the file. Sometimes there were issues getting the right formats in place a few versions ago as I recall...