Converting a Date 08/06/2004 to Julian Date 220 1

[tgorrie]

I'm trying to convert a group of dates to julian format, so I can come up with an calculation. Example: start date + Date = past due. Is there a function that does this?

Thanks

 

[JRB-Bldr]

From the VFP Help file:

SYS(11) - Julian Day Number
? SYS(11, {^1998-06-06})

Good Luck,
JRB-Bldr

 

[JRB-Bldr]

I see that I was too quick and only read part of your question. I assume that your real question was in your example. My apologies.

In VFP you can do direct Date calculations to determine the difference in number of days between Date1 and Date2.

  * --- Example ---
  mdStartDate = {^2004-02-01}
  mdToday = {^2004-08-26}

  mnDays = mdToday - mdStartDate 
  ? mnDays  && 207 Days

Good Luck,
JRB-Bldr

 

[tgorrie]

Thanks for you help!

TG