Splurd Posted June 6, 2006 Share Posted June 6, 2006 Basicly I am storing data and there are dateformats, which is all very nice and fine but I just want to check some stuff.When inputting/inserting dates into the tables thru codes, what format does the text have to be? I mean, the user only gets to input via a text box.How does searching work with dates? Does a search like find * in tb where date > 6/06/06. (which is today btw. =D)Also, is it possible to do stuff like search per month? Like find all birthdays found in july.For the record I am doing this in asp, using access .mdb as my database. Link to comment Share on other sites More sharing options...
pulpfiction Posted June 6, 2006 Share Posted June 6, 2006 Hi,You can do the search in the date fields like you mentionedSELECT * FROM datefieldname > '6/06/2006'To search based on monthSELECT * FROM MONTH(datefieldname) = 7for July Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now