Date Shows as 01/01/0001

fkmfkm · Post by **fkmfkm** » Mon Mar 03, 2008 8:55 am

Hi,

My default vb date shows as 01/01/0001. Do I have an option to display nothing if this is the case ?

Thank you

Post by **Edward** » Mon Mar 03, 2008 9:30 am

Please use the following checking in this case:

{IIF((Me.Orders.ShippedDate = "01/01/0001 00:00:00"), "", Me.Orders.ShippedDate)}

Thank you.

fkmfkm · Post by **fkmfkm** » Tue Mar 04, 2008 9:05 am

Where is the best place to put this code ?

Post by **Vital** » Tue Mar 04, 2008 11:48 am

For example you can place this expression in property Text of text component.

Thank you.