Please help, Date Format Error

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default Please help, Date Format Error

    Hello,

    Can someone please help me?



    We have developed a asp.net application which is working fine on 4 other
    computers. We have recently deplyed the application to the live environment
    running windows 2000 service pack 4, .NET v1.1.



    We continue to get the following error "Cast from string "18/07/2003" to
    type 'Date' is not valid." as the date is dmy and not mdy. We tried to
    change the server's regional settings to Australia. This did not fix the
    problem. We then tried to reinstall the framework. Still no luck.



    Is there some setting i have to change on the server or on the framework to
    use dmy date format?

    Below is an example of the asp.net source that is a corse of the problem.
    Please note that it is working on other servers and the work effort to
    change the code is not an option:



    Public Sub deletepdf(ByVal serverpath As String)
    Dim fd As System.IO.DirectoryInfo
    Dim fsArray As System.IO.FileInfo()
    Dim i As Integer

    fd = New System.IO.DirectoryInfo(serverpath + "/Temp")
    fsArray = fd.GetFiles()

    For i = 0 To fsArray.Length - 1
    If (CDate(Format(fsArray(i).CreationTime, "dd/MM/yyyy")) <
    CDate(Format(Now(), "dd/MM/yyyy"))) Then
    fsArray(i).Delete()
    End If
    Next i

    End Sub



    Please help me.



    Regards,

    Bernard.




    Bernard Guest

  2. Similar Questions and Discussions

    1. Date Format in Com+
      Hi All, I have one Component in VB6. My component receive a date as string parameter ("dd/MM/yyyy"). My componente understand "MM/dd/yyyy". Then I...
    2. Date Format
      I have a form with an unbound combo box which contains a list of choices: "Current Month";"Previous Month";"Current Year", etc. When the user...
    3. date format.
      Paul wrote: http://www.aspfaq.com/show.asp?id=2313 vbscript http://www.aspfaq.com/show.asp?id=2040 help with dates...
    4. Date() Format
      Hi Im trying to get a mm/dd/ccyy format and can nearly do this using date() however I for 02 Feb 2004 I get 2/2/2004 and I want 02/02/2004
    5. converting date into database date format(newbie)
      Hi! U can convert "8-Aug-03" into mysql date which requires yyyy-mm-dd format as below. <?php date("Y-m-d",strtotime("8-Aug-03")); ?>
  3. #2

    Default Please help, Date Format Error

    Hi

    First use the IsDate function to determine if date can be
    converted to a date or time.

    Ravikanth

    >-----Original Message-----
    >Hello,
    >
    >Can someone please help me?
    >
    >
    >
    >We have developed a asp.net application which is working
    fine on 4 other
    >computers. We have recently deplyed the application to
    the live environment
    >running windows 2000 service pack 4, .NET v1.1.
    >
    >
    >
    >We continue to get the following error "Cast from
    string "18/07/2003" to
    >type 'Date' is not valid." as the date is dmy and not
    mdy. We tried to
    >change the server's regional settings to Australia. This
    did not fix the
    >problem. We then tried to reinstall the framework. Still
    no luck.
    >
    >
    >
    >Is there some setting i have to change on the server or
    on the framework to
    >use dmy date format?
    >
    >Below is an example of the asp.net source that is a
    corse of the problem.
    >Please note that it is working on other servers and the
    work effort to
    >change the code is not an option:
    >
    >
    >
    >Public Sub deletepdf(ByVal serverpath As String)
    > Dim fd As System.IO.DirectoryInfo
    > Dim fsArray As System.IO.FileInfo()
    > Dim i As Integer
    >
    > fd = New System.IO.DirectoryInfo(serverpath
    + "/Temp")
    > fsArray = fd.GetFiles()
    >
    > For i = 0 To fsArray.Length - 1
    > If (CDate(Format(fsArray
    (i).CreationTime, "dd/MM/yyyy")) <
    >CDate(Format(Now(), "dd/MM/yyyy"))) Then
    > fsArray(i).Delete()
    > End If
    > Next i
    >
    >End Sub
    >
    >
    >
    >Please help me.
    >
    >
    >
    >Regards,
    >
    >Bernard.
    >
    >
    >
    >
    >.
    >
    Ravikanth[MVP] Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139