Android Question yesterdays date and time

S

samikinikar

Member
Licensed User
Longtime User
Can someone please guide how to retrieve yesterdays date and time ?

Date1. Yesterday date and 8:00 am time
Date2. the current date and time

I need to generate a query like "Select * from datemaster where invdate between date1 and date2

B4X: 
Dim date2 As Long = DateTime.Now
Dim date1  As Long
Dim p1 As Period
p1.Days = -1
date1= DateUtils.AddPeriod(date2, p1)
Using the above code I am able to get the yesterdays date, but I need to set the yesterdays time as 8.00 am.
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
B4X: 
Sub YesterdayAt (Hours As Int) As Long
   Dim p1 As Period
   p1.Days = -1
   Dim yesterday As Long = DateUtils.AddPeriod(DateTime.Now, p1)
   Return DateUtils.SetDateAndTime(DateTime.GetYear(yesterday), _
       DateTime.GetMonth(yesterday), DateTime.GetDayOfMonth(yesterday), Hours, 0, 0)
End Sub

Test:
B4X: 
Log($"$DateTime{YesterdayAt(8)}"$)
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4A Library [B4X] AS WheelDateTimePicker - based on ASWheelPicker
4 5 6
Replies
101
Views
31K
Alexander Stolte
  • Article
B4A Library [B4X] [XUI] AS DatePickerTimeline
3 4 5
Replies
82
Views
28K
Alexander Stolte
  • Article
B4A Library [B4X] [XUI] AS DatePicker - fast navigate to a Month - Year - Decade - Century | RangeDatePicker
2 3 4
Replies
69
Views
37K
Alexander Stolte
  • Article
B4A Library Material Date Picker
2
Replies
23
Views
11K
Lello1964
  • Question
Android Question Unparseable date
Replies
1
Views
8K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…