CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. July 12th, 2012, 02:28 PM #1
    halt4814
    halt4814 is offline Member
    Join Date
    Nov 2011
    Posts
    38

    NumberToDateString formatting issue

    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!
    Reply With Quote Reply With Quote
  2. July 12th, 2012, 03:24 PM #2
    zoneout83's Avatar
    zoneout83
    zoneout83 is offline Junior Member
    Join Date
    Jul 2012
    Location
    Ohio
    Posts
    13

    Re: NumberToDateString formatting issue

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured