Help With Julian Dates

Question

User422113880 posted

Hello all... I am new to using Crystal Reports and I am trying to build a report that look back 6 months and display each month. This is the code I am using

To find 2nd month:

BeforeReadingRecords;
100000 + ((Year(Minimum(Next31To60Days))-2000)*1000) + DATEDIFF("d",Date(Year(Minimum(Next31To60Days)),01,01),Minimum(Next31To60Days)) + 1

Can anyone help me with this? Thanks in advance

Answer 1

User422113880 posted

Have created a start and end

here is the start:

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

 

So my question now is how to convert this to julian