ToText default format for DateTime values

[afanofosc]

I have a formula displayed in the top right corner of many reports called CurrentDateTimeString. The formula is ToText(CurrentDateTime). What I want to know is exactly what Windows OS regional settings are being used by Crystal to convert that DateTime to a string when no format is specified in the ToText function. Is this documented anywhere?

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[DellSC]

Another option instead of using ToText:

1. Put a text box on the report where you want to show the date time.

2. Pull the Data Date special field into the text box.

3. Put your cursor at the end of DataDate in the text box and add a space.

4. Pull the Data Time special field into the text box.

This will show the DateTime in the format that you want it.

-Dell

[afanofosc]

Changing the hundreds of report format files that we have is not an option. What I need is someone from SAP who knows to tell me what Crystal is using to decide how to format a DateTime value using ToText without a format specified. It should be using the ShortDatePattern and LongTimePattern that I am customizing but it is not.