Importacular User Guide

⌘K
  1. Home
  2. Docs
  3. Importacular User Guide
  4. Building Your Mapping Tem...
  5. Acceptable Date Formats

Acceptable Date Formats

Importacular will attempt to import dates into Raiser’s Edge in the format that Raiser’s Edge expects. If dates are imported that do not have the expected format it may be necessary to transform them.

When transforming date formats from the incoming value into a format that Raiser’s Edge understands it is possible to create a custom format. (See dynamic dates in Data Transformations for an overview).

You create a custom format using the following combinations of letters. This is based on the .NET formatting. Please note that these formats are case sensitive.

LetterMeaning
dRepresents the day of the month as a number from 1 through 31.
A single-digit day is formatted without a leading zero
ddRepresents the day of the month as a number from 01 through 31.
A single-digit day is formatted with a leading zero
dddRepresents the abbreviated name of the day of the week (Mon, Tues, Wed etc.)
ddddRepresents the full name of the day of the week (Monday, Tuesday etc.)
h12-hour clock hour (e.g. 7)
hh12-hour clock, with a leading 0 (e.g. 07)
H24-hour clock hour (e.g. 19)
HH24-hour clock hour, with a leading 0 (e.g. 19)
mMinutes
mmMinutes with a leading zero
MMonth number
MMMonth number with leading zero
MMMAbbreviated Month Name (e.g. Dec)
MMMMFull month name (e.g. December)
sSeconds
ssSeconds with leading zero
tAbbreviated AM / PM (e.g. A or P)
ttAM / PM (e.g. AM or PM
yYear, no leading zero (e.g. 2001 would be 1)
yyYear, leading zero (e.g. 2001 would be 01)
yyyYear, (e.g. 2001 would be 2001)
yyyyYear, (e.g. 2001 would be 2001)
KRepresents the time zone information of a date and time value (e.g. +05:00)
zRepresents the signed offset of the local operating system’s time zone from
Coordinated Universal Time (UTC), measured in hours. (e.g. +6)
zzAs z but with leading zero (e.g. +06)
zzzRepresents the signed offset of the local operating system’s time zone from UTC,
measured in hours and minutes. (e.g. +06:00)
fRepresents the most significant digit of the seconds fraction; that is,
it represents the tenths of a second in a date and time value.
ffRepresents the two most significant digits of the seconds fraction;
that is, it represents the hundredths of a second in a date and time value.
fffRepresents the three most significant digits of the seconds fraction; that is,
it represents the milliseconds in a date and time value.
ffffRepresents the four most significant digits of the seconds fraction;
that is, it represents the ten thousandths of a second in a date and time value.
While it is possible to display the ten thousandths of a second component of a \time value,
that value may not be meaningful.
The precision of date and time values depends on the resolution of the system clock.
On Windows NT 3.5 and later, and Windows Vista operating systems, the clock’s resolution is
approximately 10-15 milliseconds.
fffffRepresents the five most significant digits of the seconds fraction;
that is, it represents the hundred thousandths of a second in a date and time value.
While it is possible to display the hundred thousandths of a second component of a time value,
that value may not be meaningful. The precision of date and time values depends on the
resolution of the system clock. On Windows NT 3.5 and later, and Windows Vista operating systems,
the clock’s resolution is approximately 10-15 milliseconds.
ffffffRepresents the six most significant digits of the seconds fraction;
that is, it represents the millionths of a second in a date and time value.
While it is possible to display the millionths of a second component of a time value,
that value may not be meaningful. The precision of date and time values depends
on the resolution of the system clock. On Windows NT 3.5 and later, and Windows
Vista operating systems, the clock’s resolution is approximately 10-15 milliseconds.
fffffffRepresents the seven most significant digits of the seconds fraction;
that is, it represents the ten millionths of a second in a date and time value.
While it is possible to display the ten millionths of a second component of a time value,
that value may not be meaningful. The precision of date and time values depends on
the resolution of the system clock. On Windows NT 3.5 and later, and Windows
Vista operating systems, the clock’s resolution is approximately 10-15 milliseconds.
FRepresents the most significant digit of the seconds fraction;
that is, it represents the tenths of a second in a date and time value.
Nothing is displayed if the digit is zero.
:Represents the time separator defined in the current DateTimeFormatInfo..::.TimeSeparator property.
This separator is used to differentiate hours, minutes, and seconds.
/Represents the date separator defined in the current DateTimeFormatInfo..::.DateSeparator property.
This separator is used to differentiate years, months, and days.
Represents a quoted string (quotation mark).
Displays the literal value of any string between two quotation marks (“).
Your application should precede each quotation mark with an escape character (\).
Represents a quoted string (apostrophe).
Displays the literal value of any string between two apostrophe (‘) characters.