formatdatetime

<i><b>Originally posted by : lodown</b></i><br /><br />Is it possible to use "formatdatetime=false" in an if/else statement? This is to avoid formatting a null value retrieved from a database, which in turn, creates an error message. Please help. Thanks.

<i><b>Originally posted by : Kevin (kwright@ralphs.com)</b></i><br />Try using a an if/else statement to verify if the <br />value is or is not null and then nest your 'formatdatetime' if/else statement inside.<br />FormatDateTime expects a variable value to be passed to it and cannot be used as =False or =True.<br /><br />------------<br />lodown at 3/18/2001 6:12:07 AM<br /><br /><br />Is it possible to use "formatdatetime=false" in an if/else statement? This is to avoid formatting a null value retrieved from a database, which in turn, creates an error message. Please help. Thanks.

<i><b>Originally posted by : Gavin (gavin@krazyboyz.co.za)</b></i><br />even better:<br /> use the IsDate function!<br />i.e.<br /> if isdate(TestDate) then<br />response.write formatdatetime(testdate...)<br />else<br />response.write "NoADate!"<br />end if<br /><br /><br />------------<br />Kevin at 3/19/2001 5:00:39 PM<br /><br />Try using a an if/else statement to verify if the <br />value is or is not null and then nest your 'formatdatetime' if/else statement inside.<br />FormatDateTime expects a variable value to be passed to it and cannot be used as =False or =True.<br /><br />------------<br />lodown at 3/18/2001 6:12:07 AM<br /><br /><br />Is it possible to use "formatdatetime=false" in an if/else statement? This is to avoid formatting a null value retrieved from a database, which in turn, creates an error message. Please help. Thanks.