I've had to do this so many times over the years, for all sorts of different time frames, so I decided to build, document and share my algorithms. Using ColdFusion code for the examples, the following demonstrates how to obtain the start and finish dates within the time periods:<\/p>\n
\t \t \t \t \t I've had to do this so many times over the years, for all sorts of different time frames, so I decided to build, document and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[15,34],"tags":[100],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/291"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":1,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":292,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions\/292"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<!--- YESTERDAY --->
\n\t<cfoutput><p>Yesterday:
\n\t#DateFormat(DateAdd("d",-1,NOW()), "yyyy-mm-dd")# —
\n\t#DateFormat(DateAdd("d",-1,NOW()), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code><\/p>\n<!--- TODAY --->
\n\t<cfoutput><p>Today:
\n\t#DateFormat(NOW(), "yyyy-mm-dd")# —
\n\t#DateFormat(NOW(), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code><\/p>\n<!--- LAST WEEK --->
\n\t<cfset startDate = DateFormat(DateAdd("d",-(DayOfWeek(NOW()) + 6),NOW()), "yyyy-mm-dd")>
\n\t<cfoutput><p>Last Week:
\n\t#startDate# —
\n\t#DateFormat(DateAdd("d",6,startDate), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code><\/p>\n<!--- THIS WEEK --->
\n\t<cfoutput><p>This Week:
\n\t#DateFormat(DateAdd("d",-(DayOfWeek(NOW())) + 1,NOW()), "yyyy-mm-dd")# —
\n\t#DateFormat(NOW(), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code>
\n\t
\n\t<!--- LAST MONTH --->
\n\t<cfset finishDate = DateFormat( DateAdd("d", -1, Year(NOW()) & "-" & Month(NOW())) & "-01" , "yyyy-mm-dd")>
\n\t<cfoutput><p>Last Month:
\n\t#Year(finishDate) & "-" & Month(finishDate) & "-01"# —
\n\t#finishDate#<\/p><\/cfoutput><\/code>
\n\t
\n\t<!--- THIS MONTH --->
\n\t<cfoutput><p>This Month:
\n\t#Year(NOW()) & "-" & Month(NOW()) & "-01"# —
\n\t#DateFormat(NOW(), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code>
\n\t
\n\t<!--- LAST QUARTER --->
\n\t<cfset lastQuarter = Ceiling(Month(Now()) \/ 3) - 1>
\n\t<cfif lastQuarter eq 0>
\n\t <cfset startDate = CreateDate(Year(Now()) - 1, 10, 1)>
\n\t<cfelse>
\n\t <cfset startDate = CreateDate(Year(Now()), (lastQuarter - 1) * 3 + 1, 1)>
\n\t<\/cfif>
\n\t<cfoutput><p>Last Quarter:
\n\t#DateFormat(startDate, "yyyy-mm-dd")# —
\n\t#DateFormat(DateAdd("d", -1, DateAdd("m", 3, startDate)), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code><\/p>\n<!--- THIS QUARTER --->
\n\t<cfset thisQuarter = Ceiling(Month(Now()) \/ 3)>
\n\t<cfoutput><p>This Quarter:
\n\t#Year(NOW()) & "-" & ((thisQuarter - 1) * 3 + 1) & "-" & "01"# —
\n\t#DateFormat(NOW(), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code>
\n\t
\n\t<!--- LAST YEAR --->
\n\t<cfoutput><p>Last Year:
\n\t#(Year(NOW()) - 1) & "-01-01"# —
\n\t#(Year(NOW()) - 1) & "-12-31"#<\/p><\/cfoutput><\/code><\/p>\n<!--- THIS YEAR --->
\n\t<cfoutput><p>This Year:
\n\t#Year(NOW()) & "-01-01"# —
\n\t#DateFormat(NOW(), "yyyy-mm-dd")#<\/p><\/cfoutput><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"