What you are looking for is a way to express the C language expression time(0)/86400 + 719162 in Visual Basic or VBA. time(0)/86400 is simply the number of days since a particular base date, whatever that base date is in the C language. (I'm not a C programmer, I just hack around with C when I'm not coding in REXX :) So what you are looking for becomes some way to express the number of days since 1 Jan 0001. Can you calculate days between dates? (If you prefer to calculate from a closer known base date, 1 Jan 1900 is 693595; 1 Jan 2000 is 730119.) Nathan On Tue, 9 Apr 2002 08:57:48 -0400 Steven Sobol said: >This seems to me to have the same problem as the previous answer. First, >it's not a separate field, it's part of the options field, and second, it's >an integer (probably a long integer). > >Am I not expressing the problem properly? > >-----Original Message----- >From: George Radford [mailto:[log in to unmask]] >Sent: Monday, April 08, 2002 2:56 PM >To: [log in to unmask] >Subject: Re: Visual Basic formula or function to calculate timestamps? > > >Hi Steven, > >On 12:14 PM 4/5/2002 or thereabouts, you wrote: > >When inserting a record into the database (i.e., subscribing a new list > >member), I'd like to include a timestamp so that the list owner knows when > >the list member subscribed. > >If your ASP page is doing a SQL insert or calling a SQL stored procedure, >you could use the SQL getdate() function which returns the database >server's current date and time, in datetime format. Another (even easier) >way to do this is to set the table column's default to getdate() and then >you don't have to insert anything at all -- SQL will fill it in for you >automatically if you don't supply a value in the insert statement. > >Regards, >George