[RBG7-L] - Re: Date format

[ttc . inc]

Some canned packages (such as AccPac) use a numeric data type to keep

dates and use the YYYYMMDD format.  So today's date would be stored

as 20050512, not as an actual date but simply a number.  I believe older

databases did not have a DATE type (i.e. old COBOL, etc.) and having fixed record lengths, they simply used a number. All the date functions Rbase has makes that style of structure very obsolete, but alas it is still used in many cases!

 

-Bob

 

-------------- Original message --------------

Right here in the old USA some of our government agencies also use YYYYMMDD (without the "/" separator).    As I have a client that has to electronically report data in that format, we have to convert prior to sending out the files.

 

 

Paula

 

-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Fleming
Sent: Wednesday, May 11, 2005 6:13 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Date format

Albert,

I was surprised that the YYYY/MM/DD format is used by some Canadian companies (in the same province) and not others, and even in the same company some departments do it differently. I guess a four digit year is a must. Is the year first considered the "metric" format?

When I put the above in the date picker format I get a zero for the month (???)

Dennis
*****


At 04:14 PM 5/11/2005, you wrote:

Dennis, the date picker format is a PROPERTY command

PROPERTY DatePickerID FORMAT 'FORMAT'

One format example given is
'Today''s date:' MMM dd, yyyy
I suspect some work with the quotes would be advisable LOL.


--- Dennis Fleming <[EMAIL PROTECTED]> wrote:
> (RB7- 7.1.81.30505)
>
> I think I know the suggested fix for my problem, but...
>
> If I have the date format as: MM/DD/YY
> all my dates work fine on my forms.
>
> But, at a customer who has: YY/MM/DD
> I get "invalid date" for any date change.
>
> Should I change all my forms to a four digit year (which does work) or is
> this a boo boo?
> Also, the date/time picker doesn't have a YY/MM/DD or YYYY/MM/DD format.
> And (sorry) is there a property command to change the picker format on the fly?
>
> Thanks,
>
> Dennis
> *****
> Dennis Fleming
> IISCO
> http://www.TheBestCMMS.com
> Phone: 570 775-7593
> Mobile: 570 351-5290
>
>

Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]

Dennis Fleming

IISCO

http://www.TheBestCMMS.com

Phone: 570 775-7593

Mobile: 570 351-5290