Hi,
I am using CR 8.5 with SQL server 2000. I am using the following formula for date conversion.
cdate(val(mid({Participant_Move_in_Trans.Reservation_Date},3,2)),
val(mid({Participant_Move_in_Trans.Reservation_Date},5,2)),
val(mid({Participant_Move_in_Trans.Reservation_Date},7,2)))
I am not sure how to check for zeros and null values. Can someone please help me with this?
Thanks in Advance.
Kchaudhry
I am using CR 8.5 with SQL server 2000. I am using the following formula for date conversion.
cdate(val(mid({Participant_Move_in_Trans.Reservation_Date},3,2)),
val(mid({Participant_Move_in_Trans.Reservation_Date},5,2)),
val(mid({Participant_Move_in_Trans.Reservation_Date},7,2)))
I am not sure how to check for zeros and null values. Can someone please help me with this?
Thanks in Advance.
Kchaudhry