Help With Julian Dates RSS

• • Reply
  

  TheEisdame

  Member

  9 Points

  119 Posts

  Help With Julian Dates

  Jan 03, 2013 12:39 PM|LINK

  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

  • Edited by TheEisdame on Jan 08, 2013 03:11 PM
  • Edited by TheEisdame on Jan 08, 2013 03:11 PM
• • Reply
  

  TheEisdame

  Member

  9 Points

  119 Posts

  Re: Help With Julian Dates

  Jan 08, 2013 03:13 PM|LINK

  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