Date Functions

Results 1 to 2 of 2

Thread: Date Functions

  1. #1
    Join Date
    Dec 1969

    Default Date Functions

    Hi<BR>I want to return the hour part of the current date, but the hour part has to be 7 hours before the current time.<BR>I&#039;ve tried with the dateadd function but i can&#039;t get the desired result.<BR>Maybe someone out there can help.<BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Dunno what you did wrong... I guess I&#039;ll just write it:<BR><BR> Hour( DateAdd( "h", -7, Now() ) )<BR><BR>

Posting Permissions

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