how to change the datetime format into numeric format in crystal reports
-
Hi friends, i need big help.. my programme generates a crystal reports by following view... for a given batch need to calculated the actual running time = ((starttime - endtime) - sum(temporally_stoptime - restarttime)) this calculation is done in the view..... i take the actual time in minutes.. and then cast in to integer ....view gives the correct information but when i generate the report it shows the value in datetime format .... but i need to print the numeric value in the report(even in minute format also fine).. I need to show the actual running time in minutes.. when i check the format of the field in crystal report it is numeric...but at run time it gives the value in datetime format.....:confused: all the dates in above in Database is datetime datatype.... Pls how can solve this problem..... Pls help meeee......:(( thanks...
anusha wickramaratne