DBO like this 08/09/94

[pgtek]

Hi
i have a field for birth date and i got a blank memory :-(

cr 8.5 sql database

my field is dbo and here is the data 080994
i have formula like this
@DBO

left({dbofield},2)+"/"+
mid({dbofield},4)+"/"+
right ({dbofield,2})


the first 2 digit and the last 2 digit are ok but the midlle on is not right

i want to display 08/09/94

thanks

pgtek


pgtek

 

[pgtek]

Hi
Ok found it thanks

pgtek

pgtek