AW: Date conversion question

A date is stored as binary value representing the number of days since x
within an date field.
A date format is only used to make this binary value readable.
If real dates are compared the format doesn't matter, because the binary
value is compared.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von sjl
Gesendet: Thursday, 05. August 2010 16:19
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: Date conversion question

Thanks for all responses.

I have not used date fields as often as I would like.

In JDE World software [which is my specialty], dates are stored as 6.0
numeric values in a psuedo-Julian value - dates are stored as CYYDDD. In
this representation, the first digit represent the century [when C=0,
century = 19, when C=1, century = 20], followed by the standard julian date
value.

Example:
The value 110001 is used to represent January 1, 2010.

** Another general question ***

When comparing /date/ fields, does it matter what format they are in? For
example, if I have a date field that is DATFMT(*JIS), can I compare it
successfully to a date field that is in another format, such as *ISO?

In other words, is the internal representation of a date field the same
[regardless of format], and does the DATFMT simply represent the way that it

will be displayed for human-readable purposes?

Regards,
sjl