Print Page | Close Window

WTD Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8079
Printed Date: 28 Apr 2024 at 11:51am


Topic: WTD Formula
Posted By: Msisto
Subject: WTD Formula
Date Posted: 21 Oct 2009 at 7:47am
How do I create a WTD formula for a week start day of Friday?


Replies:
Posted By: DBlank
Date Posted: 21 Oct 2009 at 8:04am
Do you mean you want records since the last Fiday based on today?
{table.datefield}>Dateadd('d',-weekday(currentdate,crFriday),currentdate)

Posted By: Msisto
Date Posted: 21 Oct 2009 at 8:33am
That's it exactly!  Works great.  Thanks!


Print Page | Close Window