View previous topic :: View next topic
|
Author |
Message |
Mahua Mitra
New User
Joined: 26 Apr 2007 Posts: 49 Location: Delhi
|
|
|
|
Hi
What is the gregorian Date format :
YYMMDD or CCYYMMDD ?
Say if I wish to use the function INTEGER-OF-DATE
Thanks |
|
Back to top |
|
|
Mahua Mitra
New User
Joined: 26 Apr 2007 Posts: 49 Location: Delhi
|
|
|
|
Let me complete the query:
Say If I wish to use the function INTEGER-OF-DATE, which amongst the two should be provided as input.
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
.... If I wish to use the function INTEGER-OF-DATE, which amongst the two should be provided as input.
|
Wouldn' t it be faster to search the doc rather than wait for a forum answer
( or search the forum ) ??
a good old plaint stupid google search pointed back to a forum post with all the details |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Use YYYYMMDD. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Ah..little more..
FUNCTION INTEGER-OF-DATE--(argument-1)
argument-1: Must be an integer of the form YYYYMMDD, whose value is obtained from the calculation (YYYY * 10,000) + (MM * 100) + DD.
- YYYY represents the year in the Gregorian calendar. It must be an integer greater than 1600, but not greater than 9999.
- MM represents a month and must be a positive integer less than 13.
- DD represents a day and must be a positive integer less than 32, provided that it is valid for the specified month and year combination.
P.S.: Well, would like to repeat enrico...
Quote: |
it be faster to search the doc |
Trust me that's rather fast.. |
|
Back to top |
|
|
|