Android Question Looking for the first date of a weeknr in the past

[parijs]

example:

I pick a date in the calendar May 2 2014 (week 21)

Now I want to know the date of the Monday and Friday of this week

 

[derez]

DateTime.DateFormat = "dd/MM/yyyy"
Dim seldate As Long = DateTime.DateParse("02/05/2014")
Dim n As Int = DateTime.GetDayOfWeek(seldate)
Dim Mt As Long = seldate - (n-2)* DateTime.TicksPerDay
Dim Ft As Long = seldate - (n-6)* DateTime.TicksPerDay
Log("Monday = " & DateTime.Date(Mt) & " Friday = " & DateTime.Date(Ft))

 

[Erel]

It is better to use DateUtils.AddPeriod:

DateTime.DateFormat = "dd/MM/yyyy"
Dim seldate As Long = DateTime.DateParse("02/05/2014")
Dim n As Int = DateTime.GetDayOfWeek(seldate)
Dim p1 As Period
p1.Days = 2 - n
Dim Mt As Long = DateUtils.AddPeriod(seldate, p1)
p1.Days = 6 - n
Dim Ft As Long = DateUtils.AddPeriod(seldate, p1)
Log("Monday = " & DateTime.Date(Mt) & " Friday = " & DateTime.Date(Ft))

 

[derez]

How about what you use in DateUtils, so you don't need the class at all:

Dim Mt As Long = DateTime.Add(seldate,0,0,2-n)
Dim Ft As Long = DateTime.Add(seldate,0,0,6-n)

 

[Erel]

Should be the same.

 

[parijs]

You guys are awesome

Thanks