Results 1 to 2 of 2

Thread: handling Null date values

  1. #1
    jim Guest

    handling Null date values

    I would like some suggestions on how to keep from displaying the value "1/1/1900" on my asp pages when my recordset field returns a Sql date value that is null

    Thanks for any tips
    Jim


  2. #2
    Nathan Guest

    handling Null date values (reply)

    I suggest using a regular expression or perl to get that changed, i ran a program
    that i made that parsed the files
    it took all the '1/1/1900' and replaced it with 'Getdate()'
    not the text getdate() but the command, which inserted the current date
    thats my only suggestion for you, i hope that this helps



    ------------
    jim at 6/30/00 3:27:19 PM

    I would like some suggestions on how to keep from displaying the value "1/1/1900" on my asp pages when my recordset field returns a Sql date value that is null

    Thanks for any tips
    Jim


Posting Permissions

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