D Declan Well-Known Member Licensed User Longtime User Sep 3, 2016 #1 I need to calculate the time (period) a student spends reading an eBook. In the Main Module I have a Process_Global variable: Code: Dim MyBookStart As Long When the eBook loads, I save to MyBookStart variable: Code: DateTime.DateFormat = "dd-MM-yyyy HH:MM:ss" Main.MyBookStart = DateTime.Date(DateTime.Now) and receive this Error: Code: java.lang.NumberFormatException: Invalid double: "03-09-2016 19:09:57"
I need to calculate the time (period) a student spends reading an eBook. In the Main Module I have a Process_Global variable: Code: Dim MyBookStart As Long When the eBook loads, I save to MyBookStart variable: Code: DateTime.DateFormat = "dd-MM-yyyy HH:MM:ss" Main.MyBookStart = DateTime.Date(DateTime.Now) and receive this Error: Code: java.lang.NumberFormatException: Invalid double: "03-09-2016 19:09:57"
imbault Well-Known Member Licensed User Longtime User Sep 3, 2016 #2 You should try mm for minutes not MM: DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" Main.MyBookStart = DateTime.Date(DateTime.Now) and mainly DateTime.Date returns a String, not a Long Upvote 0
You should try mm for minutes not MM: DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" Main.MyBookStart = DateTime.Date(DateTime.Now) and mainly DateTime.Date returns a String, not a Long
D Declan Well-Known Member Licensed User Longtime User Sep 3, 2016 #3 Nope, still the same error. I will need to convert the DateTime.Date string to a long, so that I can use: Code: Dim MyBookEnd As String Dim Diff As Period DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" MyBookEnd = DateTime.Date(DateTime.Now) Diff=DateUtils.PeriodBetween(MyBookEnd, Main.MyBookStart) Last edited: Sep 3, 2016 Upvote 0
Nope, still the same error. I will need to convert the DateTime.Date string to a long, so that I can use: Code: Dim MyBookEnd As String Dim Diff As Period DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" MyBookEnd = DateTime.Date(DateTime.Now) Diff=DateUtils.PeriodBetween(MyBookEnd, Main.MyBookStart)
imbault Well-Known Member Licensed User Longtime User Sep 3, 2016 #4 DateUtils.PeriodBetween needs ticks (Long) as parameters Upvote 0
D Declan Well-Known Member Licensed User Longtime User Sep 3, 2016 #5 Ok, but how do I achieve that? From: Code: DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" MyBookEnd = DateTime.Date(DateTime.Now) Upvote 0
Ok, but how do I achieve that? From: Code: DateTime.DateFormat = "dd-MM-yyyy HH:mm:ss" MyBookEnd = DateTime.Date(DateTime.Now)
imbault Well-Known Member Licensed User Longtime User Sep 3, 2016 #6 DateTime.Now returns Ticks (long) if you want to process a Code: Dim MyBookEnd As Long Dim Diff As Period MyBookEnd = DateTime.Now Diff=DateUtils.PeriodBetween(Main.MyBookStart, MyBookEnd) You have just to convert or to store Ticks in Main.MyBookStart Upvote 0
DateTime.Now returns Ticks (long) if you want to process a Code: Dim MyBookEnd As Long Dim Diff As Period MyBookEnd = DateTime.Now Diff=DateUtils.PeriodBetween(Main.MyBookStart, MyBookEnd) You have just to convert or to store Ticks in Main.MyBookStart