Fiscal year start to currentdate
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=22392
Printed Date: 26 Apr 2024 at 8:36pm
Topic: Fiscal year start to currentdate
Posted By: Beso90
Subject: Fiscal year start to currentdate
Date Posted: 19 Jul 2017 at 10:11am
Hello,
I have this formula:
{V_RELEASES_COMB.CUMM_SHIPPED} > 0.00 and
({@Ship Date Only} =YearToDate) and
(IsNull({V_RELEASES_COMB.EPLANT_ID}) and {@EPLANT_INCLUDE_NOT_ASSIGN} = 'Y'
or
{@USER_EPLANT_ID} = 0
or
{@USER_EPLANT_ID} = {V_RELEASES_COMB.EPLANT_ID}) and
{V_RELEASES_COMB.CUSTNO} in "30ADVA02" to "ZOME01"
The underlined bold line is what I need help with:
our fiscal year starts on July 1st. The formula by default picks up january 1st to current date. how can i change it to reflect the start of our fiscal year to current date?
Thanks,
Basel
|
Replies:
Posted By: Sastry
Date Posted: 20 Jul 2017 at 11:09pm
Hi Try below :
{@Ship Date Only} >= date(year(currentdate),07,01) and {@Ship Date Only} <= Currentdate
Thanks,
Sastry
-------------
Thanks,
Sastry
|
Posted By: Beso90
Date Posted: 16 May 2018 at 7:03am
Hello Sastry,
Now that we are in May, and it's before July, the formula isn't working. it needs to look from July 1st of last year to date. and when July this year comes, i need it to start calculating from then.
How do I fix that without manually changing the formula? How do I make the report do it automatically?
Thank you for your help
|
Posted By: Beso90
Date Posted: 25 May 2018 at 5:11am
|
Hi I really need help with this :(
|
Posted By: DBlank
Date Posted: 25 May 2018 at 5:37am
|
So you want to know when something is in the current fiscal year and your fiscal year is 7/1-6/30?
|
Posted By: DBlank
Date Posted: 25 May 2018 at 6:45am
|
table.date in DATE(datepart('yyyy',today)-(IF DATEPART('m',today)<6 then 1 else 0),7,1) to today
|
Posted By: Beso90
Date Posted: 25 May 2018 at 8:49am
|
YAAS!!!!!! This worked. Thank you!
|
|