Doug, FORMAT does not use the same conventions.
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 Doug Hamilton Sent: Wednesday, September 05, 2012 1:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: FORMAT Question Dennis, I was going through old emails last night and found this from '04. Not sure if it helps, maybe some clues? Doug This a list of values for DateTime Picker Format property Element Description d The one- or two-digit day. dd The two-digit day. Single-digit day values are preceded by a zero. ddd The three-character weekday abbreviation. dddd The full weekday name. h The one- or two-digit hour in 12-hour format. hh The two-digit hour in 12-hour format. Single-digit values are preceded by a zero. H The one- or two-digit hour in 24-hour format. HH The two-digit hour in 24-hour format. Single-digit values are preceded by a zero. m The one- or two-digit minute. mm The two-digit minute. Single-digit values are preceded by a zero. M The one- or two-digit month number. MM The two-digit month number. Single-digit values are preceded by a zero. MMM The three-character month abbreviation. MMMM The full month name. s The one- or two-digit second. ss The two-digit second. Single-digit values are preceded by a zero. t The one-letter AM/PM abbreviation (that is, AM is displayed as "A"). tt The two-letter AM/PM abbreviation (that is, AM is displayed as "AM"). yy The last two digits of the year (that is, 1996 would be displayed as "96"). yyyy The full year (that is, 1996 would be displayed as "1996"). On 9/5/2012 1:26 PM, Dennis McGrath wrote: Set var vTest = (FORMAT(.#NOW,'YY_MM_DD__HH_NN_SS.SSS')) I get the a value like this: 12_09_05__12_59_34.SSS How do I get the milliseconds to show correctly? I guessed about the NN for the minutes. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]>
