AnsweredAssumed Answered

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

Question asked by FareedKawar on Nov 25, 2009
Latest reply on Nov 25, 2009 by comment_1

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.

Outcomes