cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Find the Current Week and Previous Week

gaurav_sandil
New Contributor III

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

6 REPLIES 6

christwr
Contributor III

$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.

gaurav_sandil
New Contributor III

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, 2019

Thanks,
Gaurav Sandil

Hi 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.