Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Fiscal year start to currentdate Post Reply Post New Topic
Author Message
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet Topic: Fiscal year start to currentdate
    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
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet 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
IP IP Logged
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet 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
IP IP Logged
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet Posted: 25 May 2018 at 5:11am
Hi I really need help with this :(
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet Posted: 25 May 2018 at 8:49am
YAAS!!!!!! This worked. Thank you!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.