date

[swampy]

Whats the correct way to add the date to a DATE field from a webform? Everytime I try just using a text field using the format yyyy-mm-dd it saves it as 0000-00-00

Thanks

Rob

[swampy]

in mysql btw

[[deleted]]

I guess you are talking about mysql?
Are you 100% sure that you are inserting yyyy-mm-dd?
are you putting quotes around the value in the statement?

[swampy]

ooops, thanks 🙂

[[deleted]]

IN mysql:

SELECT if (date_field>now(),'future','past')
FROM table