Android Question Problem with DateTime

Kevin Rodríguez

New Member
Hello, I'm having a problem with my code, i want to Check the difference (In days) Between two DateTime (Long) Elements.

This is my code:


B4X: 
Dim Y, T, TP As Long
    Dim S, M, H, D As Int
   
    DateTime.DateFormat = "dd/MM/yyyy"
   
    Y= DateTime.DateParse(Last_Time)
    T= DateTime.Now
    Y= DateTime.Date(Y) + DateTime.TimeParse("00:00:01")
    T= DateTime.Date(T) + DateTime.TimeParse("00:00:01")
    TP= T- Y
    S= Round(TP/ 1000)
    M= Floor(S/ 60) Mod 60
    H= Floor(S/ 3600)
    D= Floor(H/ 24)

Last_time is a string that contains a Date from MSAccess Converted to String (like 23/05/2013) (dd/mm/yyyy)

But it throws a Java.Lang.NumberFormatException

Value of Y = 1369180800000
Value of T = 1399058075661

Help?
 
Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
Try this

B4X: 
Dim last_time As String = "23/05/2013"
Dim Y, T As Long
DateTime.DateFormat = "dd/MM/yyyy"
DateTime.TimeFormat = "HH:mm:ss"

Y= DateTime.DateTimeParse(last_time,"00:00:01")
T= DateTime.DateTimeParse(DateTime.Date(DateTime.Now),"00:00:01")
Dim diff As Period
diff = DateUtils.PeriodBetween(Y,T)
Log("Diff="&diff.Years&" years, "&diff.Months&" months, "&diff.Days&" days, "&diff.Hours&" hours, "&diff.Minutes&" minutes, "&diff.Seconds&" seconds")
Diff=0 years, 11 months, 10 days, 0 hours, 0 minutes, 0 seconds
Click to expand...
Note that you have to mark Dateutils in the LIBS-Tab
PS: Welcome to B4A community!
 
Last edited:
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
eps said:
As above use DateUtils from here
Click to expand...

Note that erel wrote in this thread:

Starting from B4A v2.70, DateUtils is included as a library in the IDE.

Kevin is a brandnew member so i suppose he is using v3.5 and therefore he dont need to download anything.

AND he is not marked as an licensed member so he cannot download additional libs. I used this example cause Dateutils is part of a fresh installation without need of download any lib.
 
Upvote 0

eps

Expert
Licensed User
Longtime User

I hadn't noticed that! Cheers
 
Upvote 0

Kevin Rodríguez

New Member
Excuse me for not introducing myself, my name is Kevin Rodríguez, i'm actually working as Software Dev in Costa Rica at a Small Place mainly dedicated to Hydrometrics.

After testing a Couple of Platforms and Stuff i got familiarized with B4A as quick as a blink, also, the Community is amazing. (Yeah guys, you're amazing ).

BTW:
DateUtils ROCKS!
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4A Class Convert DateTime, Graphic, Boolean, Units
Replies
2
Views
1K
Guenter Becker
  • Article
B4A Library [B4X] AS WheelDateTimePicker - based on ASWheelPicker
3 4 5
Replies
97
Views
16K
Alexander Stolte
  • Question
Android Question Comment links with date and time
Replies
16
Views
2K
Lucas Siqueira
J
  • Article
B4A Library DateTimePicker View
2
Replies
31
Views
11K
Sergey_New
S
P
  • Question
Android Question Unparseable date
Replies
1
Views
7K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…