Loading

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

srinivas P

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pravin More15y ago
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.
0