D
dch3
Is there a way to conditionally format a dateTime field to produce on result
if the value is 10/31/2008 12:00 AM (user didn't enter a time) and another
result if the value is 10/31/2008 5:30 PM (user entered a time). I'm looking
for this result...
Value Result
10/31/2008 12:00 AM FRI 10/31/08
10/31/2008 12:01 AM FRI 10/31/08 12:01 AM
I also need to figure out the cell spacing to force the time onto a
different line as in
10/31/2008 12:01 AM FRI 10/31/08
12:01 AM
David H
if the value is 10/31/2008 12:00 AM (user didn't enter a time) and another
result if the value is 10/31/2008 5:30 PM (user entered a time). I'm looking
for this result...
Value Result
10/31/2008 12:00 AM FRI 10/31/08
10/31/2008 12:01 AM FRI 10/31/08 12:01 AM
I also need to figure out the cell spacing to force the time onto a
different line as in
10/31/2008 12:01 AM FRI 10/31/08
12:01 AM
David H