
- 86 -
DatabaseWizard–Formattingthefields
InthisstepoftheWizardyoucanreviewthefields'namesandlengthsandmodifythem,ifnec-
essary.Youwillprobablyusemorefriendlyfieldnames,soyoucandistinguishbetweenthemmore
easily.
WhenyouarefinishedwithTextFileWizard,thestructureinformationoftheusedtextfileisstored
toaseparatefilewithaextensionof.SCH(SchemeFile).Ifyouwilltrytousethesametextfile
someothertimeonadifferentlabel,youwillbesparedalleffortsofstructurecreating.SCHfile
willbeautomaticallyusedandTextFileWizardwillbeskippedentirely.
Available Date Formats
Thedatefieldscanbeprintedinvariousformats.Inthisfieldyoudefine,howthedatewilllook.
Youcanselectsomeofthepredefineddateformatsorenteryouown.Whendefiningtheformats,
thefollowingnotationisused:
D Number of the day in a month. Can occupy one or two characters.
DD Number of the day in a month. Always occupies two characters. (leading
zeros will be added as necessary).
M M is number of the month. Can occupy one or two characters.
MM MM is number of the month. Always occupies two characters.
YY or
YYYY
The year as 2 or 4 digits number.
DDD Abbreviation of the day of week name.
DDDD The full day of week name.
MMMM The full name of the month.
MMM The abbreviation of the name of month.
J The number of days since 1. January. Can occupy from one to three char-
acters.
JJJ The number of days since 1. January. Always occupies three characters.
W The week number in current year. Can occupy one or two characters.
WW The week number in current year. Always occupies two characters.
Any other sequence of characters will be displayed unchanged. This way you
can insert dots, commas and other characters needed to properly write the
date.
The examples:
Format How the date will look
D/M/YYYY 10/3/2005
DD/MM/YY 10/03/05
DDDD, D. MMMM YYYY Thursday, 10. March 2005
JJJWWYYYY 069102005
Available Time Formats
Thetimecanbeprintedinvariousformats.Inthisfieldyoudefine,howthetimewilllook.Youcan
selectsomeofthepredefinedtimeformatsorenteryouown.Whendefiningtheformats,the
Comentarios a estos manuales