Results 1 to 4 of 4

Thread: [RESOLVED] Get the current date

  1. Mar 8th, 2007, 09:44 AM #1
    horazio
    horazio is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2006
    Location
    Paris
    Posts
    301

    Resolved [RESOLVED] Get the current date

    Hi
    I need to obtain the current date but I don't like to use Now because
    it will show the long form including hours ,minutes and seconds...
    I just want the ordinary date : dd/mm/yyyy
    Any ideas ?!
    Thanks Horazio.
    Reply With Quote Reply With Quote
  2. Mar 8th, 2007, 09:46 AM #2
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: Get the current date

    Try date or use the format command
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  3. Mar 8th, 2007, 09:48 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Get the current date

    Code:
    Dim strToday As String
strToday = Format(Now, "dd/mm/yyyy")
    Reply With Quote Reply With Quote
  4. Mar 8th, 2007, 10:30 AM #4
    horazio
    horazio is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2006
    Location
    Paris
    Posts
    301

    Re: [RESOLVED] Get the current date

    Yeah! This is what I was looking for.
    Thankyou.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width