Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [Suomi] Date null = 0000-00-00

Quote Reply
Re: [Suomi] Date null = 0000-00-00 In reply to
I read this post with interest because I wondered about this a few days ago myself.

My solution is probably not the most elegant or the "right" way to do it, but it works. I just used conditional statements within the input tags for my date fields on the add/modify record form.

Example:
<input type="text" name="date_field" value="<%if date_field == 0000-00-00%><%else%><%date_field%><%endif%>">

Hope this helps!
Subject Author Views Date
Thread Date null = 0000-00-00 Suomi 9535 Mar 17, 2002, 10:01 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 9405 Mar 18, 2002, 9:13 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 9433 Mar 18, 2002, 9:51 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 9433 Mar 18, 2002, 9:57 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 9433 Mar 18, 2002, 10:21 AM
Thread Re: [Suomi] Date null = 0000-00-00
604 9383 Mar 18, 2002, 10:40 AM
Thread Re: [TheStone] Date null = 0000-00-00
Suomi 9383 Mar 18, 2002, 11:10 AM
Post Re: [Suomi] Date null = 0000-00-00
604 9396 Mar 18, 2002, 11:30 AM
Thread Re: [Suomi] Date null = 0000-00-00
Paul 9361 Mar 18, 2002, 1:03 PM
Thread Re: [Paul] Date null = 0000-00-00
Suomi 9359 Mar 18, 2002, 4:14 PM
Thread Re: [Suomi] Date null = 0000-00-00
Halito 9364 Apr 2, 2002, 1:10 AM
Post Re: [Halito] Date null = 0000-00-00
Suomi 9374 Apr 2, 2002, 7:53 PM
Post Re: [Halito] Date null = 0000-00-00
Reena0330 9076 Aug 7, 2002, 2:12 PM