Android Question how to get last sunday date sring in "yyyymmdd" format ?

Erel said:

Sub LastSunday As Long
Dim d As Int = DateTime.GetDayOfWeek(DateTime.Now)
Dim t As Long = DateTime.Add(DateTime.Now, 0, 0, -(d-1))
Return DateUtils.SetDate(DateTime.GetYear(t), DateTime.GetMonth(t), DateTime.GetDayOfMonth(t))
End Sub

Click to expand...

hears said:

how to get last sunday date sring in "yyyymmdd" format ?

Click to expand...

Sub LastSunday As Long
    Dim d As Int = DateTime.GetDayOfWeek(DateTime.Now)
    If d=1 Then
        Dim t As Long = DateTime.Add(DateTime.Now, 0, 0, -(d-1) -7)
    Else
        Dim t As Long = DateTime.Add(DateTime.Now, 0, 0, -(d-1))
    End If
    Return DateUtils.SetDate(DateTime.GetYear(t), DateTime.GetMonth(t), DateTime.GetDayOfMonth(t))
End Sub

Mahares said:

If today's day is Sunday, your code returns today's date not last Sunday. in order to get last Sunday's date, your code should be like this:

B4X:

Sub LastSunday As Long
    Dim d As Int = DateTime.GetDayOfWeek(DateTime.Now)
    If d=1 Then
        Dim t As Long = DateTime.Add(DateTime.Now, 0, 0, -(d-1) -7)
    Else
        Dim t As Long = DateTime.Add(DateTime.Now, 0, 0, -(d-1))
    End If
    Return DateUtils.SetDate(DateTime.GetYear(t), DateTime.GetMonth(t), DateTime.GetDayOfMonth(t))
End Sub

Click to expand...