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

    Date format




      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



        • 1. Re: Date format

          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

            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

              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?





              • 4. Re: Date format

                Thanks U17152


                I will use the workaround - Strange it is happening though





                • 5. Re: Date format

                  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...