Printable View
I am using Crystal Reports 2008 and trying to change the format of a date and time. I have a number in a database that gets converted to a string using "NumberToDateString" which formats it to (for example) "Wed Jun 30 01:00:00AM 2025". How do I convert this to "06/30/2025 01:00:00AM"???? Please help!
Inside Crystal Reports I did something like this using Mid() Left() and Right() functions keep messing with those and either DateTimeValue() or CDate() and you should be able to get what you need. If your looking to do it with VB.NET you will have to export the date out into Date.ToLongDateString() or something like that. Sorry I couldn't help more.