How to Display Nothing or 0000-00-00 When the DB Date Column is Empty

Hi:

There are date fields in a particular page which don't always have data in them, yet DW always displays some value in them. As it is, when the date column is empty (no date has been previously entered in the DB) DW displays 01-01-1970 in the date field, which I suppose is the default date. I have tried entering 0000-00-00 as the default value in the DB but DW still displays that default date.

Is there any way to avoid that? Is there any way to have DW leave that page field blank or display zeros when no date has been entered in the DB?

Thank you for your attention

What code are you using to display the date on the page? If you post that I can show you how to add an IF statement to it so it won't show when blank.

Ray:

The code I'm using is this one:

<input name="adv1Date" type="text" id="adv1Date" value="<?php echo(date("d.m.Y", strtotime($row_WADApslip['adv1Date']))); ?>" size="10" readonly="readonly" />

Just in case, attached please find a copy of one of the pages that uses that code.

Use:
value="<?php echo(($row_WADApslip['adv1Date'])?date("d.m.Y", strtotime($row_WADApslip['adv1Date'])):""); ?>"

Ray:

I replaced the code as you suggested but I'm still getting 01.01.1970

Odd.. write the value to the page getting returned by the database without date formatting like:

value= "<?php echo($row_WADApslip['adv1Date']); ?>"

What does that value look like?

It shows 1970-01-01

Then I guess try:

value="<?php echo(($row_WADApslip['adv1Date'] != "1970-01-01")?date("d.m.Y", strtotime($row_WADApslip['adv1Date'])):""); ?>"

Ray:

It seems to be working. There are other similar instances in other programs where the date that appears is not 1970-01-01, but now I'll have an idea of how to go about it.

Many thanks.