4 Replies Latest reply on Nov 25, 2009 10:49 AM by comment_1

    Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only

    FareedKawar

      Summary

      Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only

      Description of the issue

      The Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formatted date only. It will display today’s date as 11/25/2009 (for example). The OS environment is Windows Server 2003 R2 Standard Edition Even, which is being used as a robot PC for the purpose of emailing. This is the case even if the 'File Options Text' tab settings are set to 'Always use system setting' and the 'Regional and Language Option' are set to English (United Kingdom)' under Windows. Again, this seems to be specific to the use of the raw Get(CurrentDate) function within the Subject and/or Message 'Specify Calculation ... ' box in the FMP 10 Send Mail script step. For example the calculation: "The following list of titles have successfully come through from Core today "  & Get ( CurrentDate ) would in the Message of the email (today Wednesday, November 11,  2009) resolve as : The following list of titles have successfully come through from Core today  11/25/2009  The only way around this is to expand the calculation to: "The following list of titles have successfully come through from Core today "  & Day ( Get ( CurrentDate) ) & "/" &  Month ( Get (CurrentDate) ) & "/" &   Year (Get (CurrentDate) ) I have not tested the sequence under another OS due to the restriction on the SMTP server, which has a port only open to specific servers of the same configuration.

        • 1. Re: Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only
          TSGal

          FareedKawar:

           

          Thank you for your post.

           

          The date format is stored with the file at the time of creation.  Therefore, if you create a database file under the US date preference, then any time you use Get (CurrentDate) in a calculation with text result, the US date preference is used.

           

          Quit FileMaker Pro.  Set your Language to English (United Kingdom).  Launch FileMaker Pro and create a new database file with one text field.  Use your calculation above with Send Mail, and you will get the correct format of 25/11/2009.

           

          Our Development and Software Quality Assurance (Testing) departments are aware of this issue.

           

          In the mean time, your workaround for the calculation, although cumbersome, is sound.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only
            FareedKawar
               <!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- [if !mso]><object classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif] --><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} p      {mso-margin-top-alt:auto;      margin-right:0cm;      mso-margin-bottom-alt:auto;      margin-left:0cm;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} @page Section1      {size:612.0pt 792.0pt;      margin:72.0pt 90.0pt 72.0pt 90.0pt;      mso-header-margin:36.0pt;      mso-footer-margin:36.0pt;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0cm 5.4pt 0cm 5.4pt;      mso-para-margin:0cm;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:"Times New Roman";      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} </style> <![endif] -->

            Thank you for your prompt response and it's good to know when issues are being worked on by the FileMaker Development and Software Quality Assurance team. This goes a long way in convincing the client that FileMaker is the viable development platform that it is.

             

            I have created a new file under the UK settings, as instructed, and I can confirm that the problem doesn't occur for this. I can also confirm that the file originated in the US but then got enhanced and hosted in the UK. Therefore, this explains how the problem arose. However, the solution is locked into this problem because it is not feasible to regenerate a new file; the man-hours needed just cannot be justified. Hence my alternative calculation formula remains the only solution.

             

            Fareed

            • 3. Re: Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only
              philmodjunk
                 You might be able to create an external file with just a foreign key field and your email text field. Then create a relationship in your original file that links your existing records to this new text field.
              • 4. Re: Get(CurrentDate) function within FMP 10 Send Mail script step resolves as US formated date only
                comment_1
                  

                FareedKawar wrote:
                <!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:WordDocument&gt;   &lt;w:View&gt;Normal&lt;/w:View&gt;   &lt;w:Zoom&gt;0&lt;/w:Zoom&gt;   &lt;w:PunctuationKerning/&gt;   &lt;w:ValidateAgainstSchemas/&gt;   &lt;w:SaveIfXMLInvalid&gt;false&lt;/w:SaveIfXMLInvalid&gt;   &lt;w:IgnoreMixedContent&gt;false&lt;/w:IgnoreMixedContent&gt;   &lt;w:AlwaysShowPlaceholderText&gt;false&lt;/w:AlwaysShowPlaceholderText&gt;   &lt;w:Compatibility&gt;    &lt;w:BreakWrappedTables/&gt;    &lt;w:SnapToGridInCell/&gt;    &lt;w:WrapTextWithPunct/&gt;    &lt;w:UseAsianBreakRules/&gt;    &lt;w:DontGrowAutofit/&gt;   &lt;/w:Compatibility&gt;   &lt;w:BrowserLevel&gt;MicrosoftInternetExplorer4&lt;/w:BrowserLevel&gt; &lt;/w:WordDocument&gt; &lt;/xml&gt;&lt;![endif]  --><!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:LatentStyles DefLockedState=&quot;false&quot; LatentStyleCount=&quot;156&quot;&gt; &lt;/w:LatentStyles&gt; &lt;/xml&gt;&lt;![endif]  --><!--  [if !mso]&gt;&lt;object classid=&quot;clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D&quot; id=ieooui&gt;&lt;/object&gt; &lt;style&gt; st1\:*{behavior:url(#ieooui) } &lt;/style&gt; &lt;![endif]  --><!--  /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:&quot;&quot;;      margin:0cm;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&quot;Times New Roman&quot;;      mso-fareast-font-family:&quot;Times New Roman&quot;;} p      {mso-margin-top-alt:auto;      margin-right:0cm;      mso-margin-bottom-alt:auto;      margin-left:0cm;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&quot;Times New Roman&quot;;      mso-fareast-font-family:&quot;Times New Roman&quot;;} @page Section1      {size:612.0pt 792.0pt;      margin:72.0pt 90.0pt 72.0pt 90.0pt;      mso-header-margin:36.0pt;      mso-footer-margin:36.0pt;      mso-paper-source:0;} div.Section1      {page:Section1;}   --><!--  [if gte mso 10]&gt; &lt;style&gt; /* Style Definitions */ table.MsoNormalTable      {mso-style-name:&quot;Table Normal&quot;;      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:&quot;&quot;;      mso-padding-alt:0cm 5.4pt 0cm 5.4pt;      mso-para-margin:0cm;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:&quot;Times New Roman&quot;;      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} &lt;/style&gt; &lt;![endif]  -->the solution is locked into this problem because it is not feasible to regenerate a new file

                Save a copy of your file as clone (no records), then import your data into the copy (don't forget to reset your serial numbers, etc.). The clone will inherit your curent system formats.