Results 1 to 2 of 2

Thread: Am/pm

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Am/pm

    Hi,

    I have a question.

    d = now
    Month(d)
    Day(d)
    Year(d)
    Hour(d)
    Minute(d)
    Second(d)

    I know that right(d,2) can retrieve the last 2 chars, AM/PM
    However, do we have a function to retrieve AM/PM value?

    Thanks.

  2. #2
    Join Date
    Aug 2005
    Location
    D/FW, Texas, USA
    Posts
    78
    If Hour(d)<12 Then
    'AM
    Else
    'PM
    End If
    --wayne
    SELECT * FROM Users WHERE Clue>0
    0 rows returned

Posting Permissions

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