Page 1 of 1

Date Shows as 01/01/0001

Posted: Mon Mar 03, 2008 8:55 am
by fkmfkm
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

Date Shows as 01/01/0001

Posted: Mon Mar 03, 2008 9:30 am
by Edward
Please use the following checking in this case:

Code: Select all

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

Date Shows as 01/01/0001

Posted: Tue Mar 04, 2008 9:05 am
by fkmfkm
Where is the best place to put this code ?

Date Shows as 01/01/0001

Posted: Tue Mar 04, 2008 11:48 am
by Vital
For example you can place this expression in property Text of text component.

Thank you.