What I am trying to do is to dial a phone number and have the program determine if that number is "busy" or "ringing". I can get the program to dial the number with no problem but to this point I have had no luck in returning anything but the number that is sent to the modem and an "OK"...
Trying to calculate the days between the date field of different records.
Example:
Field1 Field2
1 11/12/02
2 11/08/02
3 11/06/02
4 11/03/02
Result I want...
Field1 Field2 Result
1 11/12/02 4...
Is there a way to incorporate an IF..then statement in an update SQL statement?
For example if I wanted to update a date in the db, but I wanted the day to remain the same I would use the IF..then statement as follows:
if day(mydate) = day(mydate + 365) then
mydate = day(mydate +...
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.