scott_parker
Reputable Poster
Greetings
I have a bunch of WW's out there that I just found out are all messed up.
The problem is-- I use a calculated field to subtract two Julian dates to get the number of days between. Or number of Days Late.
Well Julian now wont work if one date is a 2000 date and the other is 2001.
Unfortunately, this isn't always the case either. Most of the times they are within the same year.. But this being January.. Request date and ship date could (and do) Span the year end.
Also, When selecting in WW where One days = Another Date I end up having to make 2 calculated fields with just the Julian date as a value..
JDE Needs to fix that. IMHO.
Any Ideas?
Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
I have a bunch of WW's out there that I just found out are all messed up.
The problem is-- I use a calculated field to subtract two Julian dates to get the number of days between. Or number of Days Late.
Well Julian now wont work if one date is a 2000 date and the other is 2001.
Unfortunately, this isn't always the case either. Most of the times they are within the same year.. But this being January.. Request date and ship date could (and do) Span the year end.
Also, When selecting in WW where One days = Another Date I end up having to make 2 calculated fields with just the Julian date as a value..
JDE Needs to fix that. IMHO.
Any Ideas?
Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5