Solved

Last Monday of Last Year

Posted on 2013-01-14
1
328 Views
Last Modified: 2013-01-15
Using CR2008

I am looking to find the date of last Monday of the last year (in the current case this would be 31/12/2012.) This will be used in a formula for subsequent years.

Can anybody help?

Thanks
0
Comment
Question by:halifaxman
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38774869
This will give you the last monday:

datevar yend;
yend:=dateserial(year(currentdate)-1, 12,31);
yend-dayofweek(yend)+2
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question