Results 1 to 5 of 5

Thread: Retrive date in sql or vb.6

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-09-2008, 11:39 AM #4
    Demosthine
    Demosthine is offline
    VBAX Tutor Demosthine's Avatar
    Joined
    Sep 2008
    Posts
    238
    Location
    Good Morning.

    You can either nest the DateAdd to add a year and subtract a day
    DateAdd("yyyy", 1, Date("d", -1, [JoinDate])) AS [NewDate]
    - OR -

    Take the number of days in a normal year and subtract 1.
    DateAdd("d", 364, [JoinDate]) AS [NewDate]
    Take care.
    Scott
    Last edited by Aussiebear; 03-27-2025 at 12:39 PM.
    You don't understand anything until you learn it more than one way. ~Marvin Minsky

    I never teach my pupils; I only attempt to provide the conditions in which they can learn. - Albert Einstein
    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