i want to caliculate minutes diff between two timings
2008-09-10 23:23:53.077(entry time)
2008-09-10 14:33:19.140(exit time)
plz any one tell me difference
i want to caliculate minutes diff between two timings
2008-09-10 23:23:53.077(entry time)
2008-09-10 14:33:19.140(exit time)
plz any one tell me difference
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
jeevan mummadiPosted May 27, 2009, 6:15 AM
Vimal KandasamyPosted May 27, 2009, 5:49 AM
DateTime t1 = DateTime.Parse("2008-09-10 23:23:53.077");DateTime t2 = DateTime.Parse("2008-08-10 14:33:19.140");The above code will retrieve no of days between given dates.
i have one doubt.Exit time will be greater than entry time na?... then how negative values will come?..
jeevan mummadiPosted May 27, 2009, 5:00 AM
thanks vimal,
i wrote datedifference formula in crystalreports like this
datediff("n",{GeofenceDetails.EntryTime},{GeofenceDetails.ExitTime})
for some two timings difference i get negative values
i want to dispaly only +ve values for my report output
pls give me any solution ...
Vimal KandasamyPosted May 27, 2009, 3:28 AM
DateTime t1 = DateTime.Parse("2008-09-10 23:23:53.077");DateTime t2 = DateTime.Parse("2008-09-10 14:33:19.140");Rodick WuPosted May 27, 2009, 3:18 AM