Make sure your year and century setting are set up dynamically so they will always be right.
SET VAR vYearText = (CTXT(IYR4(.#DATE) - 90)) SET VAR vTmp = (SGET(.vYearText,2,1)) SET DATE CENTURY &vTmp SET VAR vTmp = (SGET(.vYearText,2,3)) SET DATE YEAR &vTmp In this year, 2014, this will set up the century = 19 and year = 24 if anyone types in a 2 digit year it will be interpreted as being between 1924 and 2023. Depending on your application, you might want to adjust the first line to suit your needs Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Monday, January 13, 2014 9:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Datetime issue I created my own problem and now will always use Razz's startup settings for everything Tom Hart ________________________________________ From: Karen Tellef <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, January 13, 2014 9:37 AM Subject: [RBASE-L] - Re: Datetime issue One thing I'll share that caused us a weird issue regarding "time". All my clients use this time format: TIME format HH:MM:SS TIME sequence HHMMSS At one of them, we started having a problem where an old program would select a Max(datetimecolumn) from a table, and then do an "edit using <form> where datetimecolumn = .theValue". And it all of a sudden started failing. It took a "bug" report to RBTI for them to point out what my problem was! The time settings had changed to this: TIME format HH:MM AP TIME sequence HHMMSS Using 9.5's "find in forms" feature, I found that another programmer on the job had used some RRBYW code that had specified that time format! So there was a mismatch between the sequence and the format and that prevented the "where" clause from working. Whoopsy! Karen -----Original Message----- From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, Jan 12, 2014 6:34 pm Subject: [RBASE-L] - Re: Datetime issue At 06:41 PM 1/11/2014, Tom Hart wrote: >That is what I did different, I copied from your earlier post but >somehow the set time format was HH:MM:SS, I have that resolved now. Tom, I am glad to hear that. >Why does that affect the datetime stamp? For your education ... Every UNLOAD routine (except AS ASCII), always carries the native settings as follows: CHARACTER Settings BLANK DELIMIT LINEEND SEMI QUOTES PLUS SINGLE MANY IDQUOTES CURRENCY Settings SYMBOL PREF and SUFF Subunit Digits FORMAT Operating Conditions CASE AUTOSKIP REVERSE BELL TOLERANCE ZERO Special Character NULL DATE Settings YEAR CENTURY SEQUENCE TIME Settings SEQUENCE These settings are enforced to assure the successful LOAD of the unloaded file. So, when you are loading and implementing someone else's form, external form, label, report, or table/view structure, after a successful load, it is your responsibility to verify and reset your database settings, if necessary. Thus, the need to enforce all default settings in your startup application file, as suggested in my earlier reply. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
