vishbaan
9th May 2002, 09:20
Dear Fans

How BaaN recognises a bad date like Feb 30, 2002.

Does it have preloaded data or any predefined functions?

tks

Vish

lbencic
16th May 2002, 17:58
Vish -
In Baan IV, the dates are stored as a long number, counting the number of days since 01-01-01. The date you mentioned would need to be translated into a Baan date using predefined Baan functions. You can find them in the manual, probably inputstr.to.date() would be the most useful for your purpose, though you need to play with which format is defined on your system for the date format you are passing. If you pass it a bad value that cannot be translated, it will return -1 for you.

In Baan V, you use the utc date functions, but the same functionality exists.

FransG
17th May 2002, 09:41
FYI

The utc dates in BaanERP contain both a date and time element. It stores both date and time in a single long integer. This long represents the number of seconds since 00:00:00 of january 1st 1970. The upper limit of a utc date is somewhere in 2038.

vishbaan
20th May 2002, 08:06
Thanks

So the built-in function does the validation based on date format.

can you tell me what is utc


Vish

~Vamsi
20th May 2002, 08:52
http://aa.usno.navy.mil/faq/docs/UT.html

The implementation is explained in the Baan Tools manual. The short of it is: Baan keeps track of time in seconds from January 1st, of some year in the seventies. On current hardware this would mean that the time would "rollover" in 2039.