How to calculate the execution time between two dates

Question

Hi friends I have date_start and date_end And I want to know the deadline in year This is in crystal report How to do please thank you in advance

Amit Gupta · Answer

Use the Parameter field from the field explorer. Have a look to the below link FYI http://www.c-sharpcorner.com/UploadFile/009464/crystal-report-with-parameter-in-Asp-Net-using-C-Sharp/ In the code behind use the logic and pass the parameter​ value to crystal report

ma ouml · Answer

Amit Gupta I do not know how to do can you give me an example or I will write

Amit Gupta · Answer

Use Report parameter and pass the value from code behind. var year = (endDate-startDate).Year;

ma ouml · Answer

but I need time between start and end date like in years in crystal report

Manas Mohapatra · Answer

Try like this: SELECT (DATEDIFF(mm startdate enddate) +1)/12 as NoOfYears

ma ouml · Answer

I need time between start and end date like in years

Manas Mohapatra · Answer

Do you need time between start and end date like in days or hours or minutes.. Please provide details..