Greetings,
VB5/VB6, Win95/WinNT4
I have been getting following errors while installing VB apps. The same
setup sometimes installs without any problems, but sometimes it gives
problems. Most of the times the setup is not able to register the Crystal32
OCX and one of my DLLs (2, 3 below). As far...
I need help selecting a contractor 1st log record and last log record for each day.
Contractor_Table
Co_# SSN LOG_DATETIME
100 012349991 4/27/2003 9:29:39 AM
100 012349991 4/29/2003 8:34:57 AM
100 012349991 4/30/2003 8:34:57 AM
100 012349991 4/30/2003 9:29:39 AM...
I tried using between dateserial to give me the first day of the previous month and last day of previos month.
eg. between #4/1/2003# and #4/30/2003#
The code I used is:
Between DateSerial(Year(Date()),Month(Date()-1),1) And DateSerial(Year(Date()),Month(Date()-1)+1,0)
I am getting back...
How can I use between dateserial to give me the first day of the previous month and last day of previos month.
eg. between #4/1/2003# and #4/30/2003#
The code I used is:
Between DateSerial(Year(Date()),Month(Date()-1),1) And DateSerial(Year(Date()),Month(Date()-1)+1,0)
I am getting back...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.