Date Search

On my Admin pages, I can only search Orders if I type in the entirely date as it appears in my database ("10/3/2009 9:12:05 PM"), if I type in anything else, the search either comes up empty or produces an error.

How can I change it to where we can search orders by just typing in mm/yyyy or something similar?

The first thing to try would be to update the DataAssist Search server behavior to work with > and < values instead of equals. This should get it so there does not need to be an exact match.

You could also reformat the date in PHP with the strtotime and date functions. Give this a try first and see if it gets the results you are looking for. If you need to do some formatting I can help give you some pointers on that.

Well, I tried all kinds of combinations of 'Greater Than', 'Less Than', 'Less or Equal To' etc but it didn't seem to make one bit of difference. (Type is still set to "Edit", right?)

So perhaps I need to add some code afterall. I use ASP btw

I was not aware of using ASP. This changes things a bit since date formatting and other functionality are greatly limited in ASP compared to PHP. Is the data in an access db? If so are you selecting date MS Access as the data type? Please post back with this detail so we have a better idea about the environment. If I need to I will open a ticket so we can exchange some files.

Thanks, Eric.

After a little searching I learned there is also a function called Date() to use as your default value in your database columns. I was using Now() which adds all the HR, MIN, SEC stuff behind the date... I'm new to all this, i had no idea.

Anyway, after I set the DA Search behavior to "Greater than or equal to", I can now type in "october 2009", and it'll give me all the orders for Oct 09. Problem solved :)

Thanks again!

I happy to hear that you got that sorted out. Sorry I was able to provide that missing piece to you.