Unanswered: How to check/update yes/no fields and set date
Can some1 help me with this? How do i check/update yes/no fields of a DB. Also how can i set the current date plus 2 weeks in a date/time field with the format being general date (6/30/08). And to save some time how can i check today's date against it?
It would help if we knew what database you were asking about. Generally speaking, "yes/no" fields are represented by a bit that is either on or off (1 or 0). The date part of your question depends entirely on the type of database you use.
i figured out the yes/no fields by just setting it to true. it is a MS access DB. doubt it makes a difference but it's suffix is .mdb instead of the newer one. i think i found out how to add to the date from http://www.w3schools.com/Vbscript/func_dateadd.asp. but i'm wondering how i can post the current date in the DB.