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]

I believe it will use whatever the Windows Default format is for the computer where it's being run.

-Dell

[afanofosc]

That is definitely not what Crystal does. There is no "Windows Default format" for a combined Date and Time value. In C# there is a "standard format" called "G" which is not defined at the OS level. For C# that means "short date plus a space plus long time" but in our software prior to running a Crystal report using the .Net C# classes provided by Crystal if I change the current thread CultureInfo DateTimeFormatInfo object's ShortDatePattern and its LongTimePattern Crystal is ignoring those changes when it outputs a full DateTime value using ToText in a report but it is using the ShortDatePattern when it formats a Date field on the same report. The ToText(CurrentDateTime) field is set to "use default" formatting, i.e., not custom field formatting. The same is true for the Date fields. But nothing I have tried is able to convince Crystal to use the custom ShortDatePattern and LongTimePattern values that I have specified for the current thread when it outputs a DateTime value using the ToText function with no format specified.