Extra Fields - Date format

[objelland]

Hi

I have searched this forum for hours, but I still can't find a good solution for adding an extra field as a date field.

What I need to do is to be able to enter a date in the checkout process. This date tells when content of the the listing will be available. It also has to be searchable.

Does anyone know anything about how this can be done?

Thank you!

Regards,

Oyvind

[Lhotch]

I would probably just create an axtra text field and then implement the littl javascript calender that in use in admin for searching for ads. Then the member can select a date from the calendar and the input would always be consistant. You would then of course need to include the calendar on the search page as well and in the ad placement heckout.

[objelland]

Hi, and thank you for your feedback.
That is exactly what I was thinking, but there is only one problem. I need the field to be searchable using " search value > extra field" or "search value < extra field" values.
Can this be done by doing it the way you suggest?

Thanks!

Oyvind

[Lhotch]

Originally Posted by objelland

Hi, and thank you for your feedback.
That is exactly what I was thinking, but there is only one problem. I need the field to be searchable using " search value > extra field" or "search value < extra field" values.
Can this be done by doing it the way you suggest?

Thanks!

Oyvind

Do you mean you want people to be able to seach by a date greater or less than? anything can be done but how much work it would be is the real question.

I would think you could add a field to the search where the user could select a greater or less than dropdown that could be passed along to the search script and used in the query.

[objelland]

Yes, that is what I mean. Sorry for bad explanation.
So you suggest that I use a drop down list for this?
This is a good idea, but will such a search be useful for "dates" in text format?

Regards
Oyvind

[Lhotch]

Originally Posted by objelland

Yes, that is what I mean. Sorry for bad explanation.
So you suggest that I use a drop down list for this?
This is a good idea, but will such a search be useful for "dates" in text format?

Regards
Oyvind

Here is where I would star, dont know if it would be an idea choice or not without looking deeper into the code.

Create an extra text field and make it searchable.

On the ad checkout have the little calender widget so people can pick a date and it will automatically populate the extra text field.

On the search page add the calendar widget so people can select a date that auto populates the search firld for the date.

Now, create a hand made (not a defined extra field or anything) dropdown box that has something like "before date" and "after date".

alter the search script to gather the dropdown field you created and adjust the database query accordingly.

[objelland]

Thank you very much for your help, I really appreciate it.
I will give this a try, and let you know how it goes!

Oyvind