Need help putting in right Date format for Now().

snteran · May 22nd, 2012, 01:06 PM

I have a page that we will be updating a field. I have a hidden field that carries over to an update page. I only want the Date without the time.

Code:

Code:

cpReviewDate = Now()	

 <INPUT TYPE="Hidden" NAME="cpDate" VALUE="<%= cpReviewDate %>">

This then gets processed in my update page:

Code:

objRS("cp_ReviewDate") = Request.Form("cpDate")
objRS("buildTech") = Request.Form("buildTech")
objRS.Update

End result right now shows: 5/21/2012 5:04:32 PM

I would only like to show the date and not the time: 5/21/2012.

Please let me know if any more information is needed.

Thanks

snteran · May 22nd, 2012, 01:11 PM

Well, that did not take long. I found in one of my old books, change Now() to Date(). Created the correct format.

Thanks

mat41 · May 22nd, 2012, 07:49 PM

HI there - nice of you to blow the dust of this forum category, it doesn't get much action these days...

When dealing with dates and date formats you can either gamble and roll the dice as you are doing by using date() and now() or write functions to ensure not only the part of the date/time are there but they are in the format you want EG dd/mm/yyyy is essential for Australia. SO:

when I insert a record into SQL Server I like to always store using American mm/dd/yyyy format so I do use this function:

Code:

  FUNCTION amDate(varDate)
      IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
        amDate = "Null"
      ELSE
        amDate = "'" & Month(DateValue(varDate)) & "/" & Day(DateValue(varDate)) & "/" & Year(DateValue(varDate)) & " " & TimeValue(varDate) & "'"
      END IF 
  END FUNCTION

and when I get records from the DB I display it using either of these functions, the first one shows just the date and the second one the date and time:

Code:

  FUNCTION auDate(varDate)
      IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
        auDate = "Null"
      ELSE
        auDate = "" & Day(DateValue(varDate)) & "/" & Month(DateValue(varDate)) & "/" & Year(DateValue(varDate)) & ""
      END IF 
  END FUNCTION
  
  FUNCTION auDateTime(varDate)
      IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
        auDateTime = "Null"
      ELSE
        auDateTime = "" & Day(DateValue(varDate)) & "/" & Month(DateValue(varDate)) & "/" & Year(DateValue(varDate)) & " " & TimeValue(varDate) & ""
      END IF 
  END FUNCTION

Then once you build your functions up you will use then everywhere....