How to write formula field for requiredformat of Date andTime using Crystal Reports?

Question

Hi 2 all i have designed one report in that i have getting date from backend table. my requirement is in table date format is MM/DD/YYYY In my report i want to display that format to DD/MM/YYYY How to write formula field for this? thanks inadvance

Pravin More · Answer

Hi srinivas You can convert it in your C# or VB (whatever you are using) code and then pass to crystal report like this..... DateTime.ToString(DD/MM/YYYY) using above Method and provide as a String to Crystal report. Thanx Pravin.