if {?Date}="mm/dd/yyyy" then
   True
else
    Date({TABLE.MN_DT_TM}) = Date(ToNumber(Right({?Date},4)), ToNumber(Left({?Date},2)),    
        ToNumber(Mid({?Date},4,2)))


i UNDERSTAND THE IF CONDITION BUT CAN YOU EXPLAIN ELSE.


tHANKS
nAMMU

Thanks for the reply .


What does the last 4,2 in the formula represent.

It picks the mid value which is date and converts into number, I hope this is what it does, but what does the 4, 2 represent ?


Thanks
Nammu