hi friends 
,
i want to display the record from sql server field with vb.2005 & sql server 2005
the sql fieldname is period1 with datatype varchar(50) it contains date format like 8/12/2009. i don't use any datetime field.
when i display it into crystal report viewer it doesn't have no error.
but i'm having trouble how to separate it into date, month, year..
i was trying by manipulate the IFieldObject width but still i have the trouble when i want to display middle string data..
my question :
1. i want to substring the 8/12/2009 text, then i want to display it into the report with values 8. how i do it ?
thank you so much for any replies
,i want to display the record from sql server field with vb.2005 & sql server 2005
the sql fieldname is period1 with datatype varchar(50) it contains date format like 8/12/2009. i don't use any datetime field.
when i display it into crystal report viewer it doesn't have no error.
but i'm having trouble how to separate it into date, month, year..
i was trying by manipulate the IFieldObject width but still i have the trouble when i want to display middle string data..
my question :
1. i want to substring the 8/12/2009 text, then i want to display it into the report with values 8. how i do it ?
thank you so much for any replies
Last edited:
