Find the Current Week and Previous Week
Hi,
I am looking for a function which can give me the Current Week.
For instance the current date is 2019-03-01 , so the week would be Week 9 and the Previous week is Week 8.
Thanks,
Gaurav Sandil
Forum Discussion
6 Replies
$CurrentWeekOfYear = Date.now().toLocaleDateString({“format”:“w”})
$PreviousWeekOfYear = Date.now().minusWeeks(1).toLocaleDateString({“format”:“w”})Can also wrap a parseInt() around it if want in number data type.
Thanks a lot christwr. I will definitely give it a try.
Hi Christwr,
It worked for me. Thanks…
Can I ask something more here.
If I get the Week number as 9 then I want the Start Date as 2019-02-25 00:00:00 and End Date as 2019-03-03 23:59:59 as in Week 9 we have date as February 25, 2019 to March 3, 2019Thanks,
Gaurav SandilHi Gaurav,
Start Date:-Date.parse(_date).minusMonths(Date.parse(_date).getMonth()-1).minusDays(Date.parse(_date).getDate()-1).plusDays(Date.parse(_date).toLocaleDateString({“format”:“w”})*7-8)End Date :- Date.now().minusMonths(Date.now().getMonth()-1).minusDays(Date.now().getDate()-1).plusDays(Date.now().toLocaleDateString({“format”:“w”})*7-8).plusDays(6)
This might help you to achieve what you are trying.
Thanks Ajay. I tried below statement and it worked for me:
$weekstartdate =
Date.now().minusWeeks(1).withHourOfDay(0).withMinuteOfHour(0).withSecondOfMinute(0).withMillisOfSecond(0)$weekenddate = Date.now().minusWeeks(1).plusDays(6).withHourOfDay(23).withMinuteOfHour(59).withSecondOfMinute(59).withMillisOfSecond(0)
