Re: [QF-Test] how can I convert month number to month text in QFS

Got it. Thanks Denis!

[@@ THALES GROUP INTERNAL @@]

Hi Yi,

Internally the qfs.utils.getDate uses a Java SimpleDateFormat to generate the string representation of the date.

The way the format argument of this procedure is processed is then in accordance to the Java documentation for this class (see here).

So to directly answer your question:

                rc.callProcedure("qfs.utils.getDate",{"format":"MM"})  è 04

                rc.callProcedure("qfs.utils.getDate",{"format":"MMM"})             è Apr

                rc.callProcedure("qfs.utils.getDate",{"format":"MMMM"})         è April

Cheers,

Denis GAUTHIER

This message contains THALES GROUP INTERNAL information that is intended to be non-public information that must only be disclosed to others on a need-to-know basis. Other organisations receiving this message should treat it the same as COMMERCIAL-IN-CONFIDENCE

This email was classified byGauthier, Denis on Friday, 19 April 2013 4:47:50 PM

Hi,

In one of our invoicing parameters window,  current month should be set as default value.

I’ve used the following and get the month of ‘04’.  This is correct. Would you please let me  know how I can convert 04 to April?

Month= rc.callProcedure("qfs.utils.getDate",{"format":"MM"})

(result: Expansion of retval: '$(date)' => '04')

Thank you very much in advance!

Yi

This communication and attachment(s) are the confidential property of INVISION, Inc. If you are not the intended recipient, please notify the sender immediately and delete this message; any copying, dissemination or use of these contents by persons other than the intended addressee(s) is prohibited. Thank you.

------------------------------------------------------------------------- DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. -------------------------------------------------------------------------