My goal is to show 6 months of data so in the code below i was able to show the start and end date for each month but trying to conver that start and end into julian start and end is what i having a hard time with, by the way this reporting is being created
in Crystal Reporting
BeforeReadingRecords;
Local dateVar back2;
Local dateVar back2start;
back2 := CDate(DateAdd("m",-6,CurrentDate));
back2start := Date(Year(back2),Month(back2),01);
back2start
END
BeforeReadingRecords;
Local dateVar back2;
Local dateVar back2end;
back2 := CDate(DateAdd("m",-5,CurrentDate));
back2end := CDate(DateAdd("d",-1,Date(Year(back2),Month(back2),01)));
back2end
TheEisdame
Member
9 Points
119 Posts
Julian Date Convertion Help
Jan 18, 2013 03:20 PM|LINK
Hello World!
<div>My goal is to show 6 months of data so in the code below i was able to show the start and end date for each month but trying to conver that start and end into julian start and end is what i having a hard time with, by the way this reporting is being created in Crystal Reporting
BeforeReadingRecords;
Local dateVar back2;
Local dateVar back2start;
back2 := CDate(DateAdd("m",-6,CurrentDate));
back2start := Date(Year(back2),Month(back2),01);
back2start
END
BeforeReadingRecords;
</div>Local dateVar back2;
Local dateVar back2end;
back2 := CDate(DateAdd("m",-5,CurrentDate));
back2end := CDate(DateAdd("d",-1,Date(Year(back2),Month(back2),01)));
back2end
TheEisdame
Member
9 Points
119 Posts
Re: Julian Date Convertion Help
Jan 18, 2013 04:26 PM|LINK
also, can some help me with the definition of this line... What does the numbers means? like 100000 , -2000 * 1000
100000 + ((Year(Maximum(MonthToDate))-2000)*1000) + DATEDIFF("d",Date(Year(Maximum(MonthToDate)),01,01),Maximum(MonthToDate))