1.877.833.1202

Custom Date, Time and Custom Currency Formats

If the default date/time and currency symbol formats provided with the document management software does not meet your needs, the formats can be modified by editing a resource file on the FileHold server.

Default Date and Time Settings

There are 13 default date/time formats that can be customized and up to 7 custom date/time formats can be added to the resource file. The default date/time formats are:

  • MM/dd/yyyy
  • MM/dd-yyyy
  • MM/dd/yyyy h:mmtt
  • MM/dd/yyyy H:mm
  • dd-MM-yyyy
  • dd-MMM-yyyy
  • MMM-dd-yyyy
  • MMMM dd, yyyy
  • yyyy-MM-dd
  • yyyyMMDD
  • yyyyddMM
  • ddMMyyyy
  • MMddyyyy

Default Currency Symbols

You can customize up to 6 currency symbols. The default currency symbol formats are:

  • $
  • £
  • ¥
  • Kr
  • R

Modifying the Custom Date/Time Formats

To modify the date/time format

  1. Locate the GlobalResources.resx file in Libaray Manager web service. It should be located in c:\Inetpub\wwwroot\fh\FileHold\LibraryManager\App_GlobalResources (Windows Server 2003) or C:\Program Files\FileHold Systems\Application Server\LibraryManager\App_GlobalResources (Windows Server 2008 and 2012).
  2. Make a copy of this file before proceeding.
  3. Open the file for editing using an application such as Notepad or Notepad ++.
  4. Identify the following section in the resource file:

<data name="DateFormat1" xml:space="preserve">
    <value>MM/dd/yyyy</value>
    <comment>Number after name DateFormat means place in the list of date format on the page creating Date metadata field</comment>
  </data>
  <data name="DateFormat2" xml:space="preserve">
    <value>MM/dd-yyyy</value>
  </data>
  <data name="DateFormat3" xml:space="preserve">
    <value>MM/dd/yyyy h:mmtt</value>
  </data>
  <data name="DateFormat4" xml:space="preserve">
    <value>MM/dd/yyyy H:mm</value>
  </data>
  <data name="DateFormat5" xml:space="preserve">
    <value>dd-MM-yyyy</value>
  </data>
  <data name="DateFormat6" xml:space="preserve">
    <value>dd-MMM-yyyy</value>
  </data>
  <data name="DateFormat7" xml:space="preserve">
    <value>yyyyMMdd</value>
  </data>
  <data name="DateFormat8" xml:space="preserve">
    <value>MMMM dd, yyyy</value>
  </data>

  1. Each subsection defines one date and time format. Select the date/time format that is not required and delete text between <value></value>. For example:

<data name="DateFormat2" xml:space="preserve">
    <value></value>
  </data>

  1. Enter the new date/time format. See the following table below for more information on date/time formats. For example:

<data name="DateFormat2" xml:space="preserve">
    <value>yyyyMMdd</value>
  </data>

  1. To add an additional date/time format (up to 20 can be used), copy the following code and increase the DateFormat number by one. For example "DateFormat14". Enter a new date/time format between <value></value>.

<data name="DateFormat#" xml:space="preserve">
    <value></value>
  </data>

  1. Save the GlobalResources.resx file.

TIP: When you upgrade your FileHold system make sure you copy any custom changes from your old resource file to your new resource file.

Modifying the Currency Symbol Formats

To customize the currency symbol format

  1. Locate the GlobalResources.resx file in Libaray Manager web service. It should be located in c:\Inetpub\wwwroot\fh\FileHold\LibraryManager\App_GlobalResources (Windows Server 2003) or C:\Program Files\FileHold Systems\Application Server\LibraryManager\App_GlobalResources (Windows Server 2008).
  2. Make a copy of the file before proceeding.
  3. Open the file for editing using an application such as Notepad.
  4. Identify the following section in the resource file:

<data name="CurrencySymbol1" xml:space="preserve">
    <value>$</value>
  </data>
  <data name="CurrencySymbol2" xml:space="preserve">
    <value>£</value>
  </data>
  <data name="CurrencySymbol3" xml:space="preserve">
    <value>€</value>
  </data>
  <data name="CurrencySymbol4" xml:space="preserve">
    <value>¥</value>
  </data>
  <data name="CurrencySymbol5" xml:space="preserve">
    <value>Kr</value>
  </data>
  <data name="CurrencySymbol6" xml:space="preserve">
    <value>R</value>
  </data>

  1. Each subsection defines one currency symbol format. Select the currency symbol format that is not required and delete text between <value></value>. For example:

<data name="CurrencySymbol2" xml:space="preserve">
    <value></value>
  </data>

  1. Enter the new currency symbol format up to 3 characters. For example:

<data name="CurrencySymbol2" xml:space="preserve">
    <value>
BZ$</value>
  </data>

  1. Save the GlobalResources.resx file.
  2. Restart Web Server (IIS).

Date and Time Format Identifiers

Format identifier

Description

Examples

"d"

The day of the month, from 1 through 31.

More information: The "d" Custom Format Specifier.

6/1/2009 1:45:30 PM -> 1

6/15/2009 1:45:30 PM -> 15

"dd"

The day of the month, from 01 through 31.

More information: The "dd" Custom Format Specifier.

6/1/2009 1:45:30 PM -> 01

6/15/2009 1:45:30 PM -> 15

"ddd"

The abbreviated name of the day of the week.

More information: The "ddd" Custom Format Specifier.

6/15/2009 1:45:30 PM -> Mon (en-US)

6/15/2009 1:45:30 PM -> Пн (ru-RU)

6/15/2009 1:45:30 PM -> lun. (fr-FR)

"dddd"

The full name of the day of the week.

More information: The "dddd" Custom Format Specifier.

6/15/2009 1:45:30 PM -> Monday (en-US)

6/15/2009 1:45:30 PM -> понедельник (ru-RU)

6/15/2009 1:45:30 PM -> lundi (fr-FR)

"f"

The tenths of a second in a date and time value.

More information: The "f" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> 0

"ff"

The hundredths of a second in a date and time value.

More information: The "ff" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> 00

"fff"

The milliseconds in a date and time value.

More information: The "fff" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> 000

"ffff"

The ten thousandths of a second in a date and time value.

More information: The "ffff" Custom Format Specifier.

6/15/2009 13:45:30.6175 -> 6175

6/15/2009 13:45:30.00005 -> 0000

"fffff"

The hundred thousandths of a second in a date and time value.

More information: The "fffff" Custom Format Specifier.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> 00000

"ffffff"

The millionths of a second in a date and time value.

More information: The "ffffff" Custom Format Specifier.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> 000000

"fffffff"

The ten millionths of a second in a date and time value.

More information: The "fffffff" Custom Format Specifier.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 0001150

"F"

If non-zero, the tenths of a second in a date and time value.

More information: The "F" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 6

6/15/2009 13:45:30.050 -> (no output)

"FF"

If non-zero, the hundredths of a second in a date and time value.

More information: The "FF" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 61

6/15/2009 13:45:30.005 -> (no output)

"FFF"

If non-zero, the milliseconds in a date and time value.

More information: The "FFF" Custom Format Specifier.

6/15/2009 13:45:30.617 -> 617

6/15/2009 13:45:30.0005 -> (no output)

"FFFF"

If non-zero, the ten thousandths of a second in a date and time value.

More information: The "FFFF" Custom Format Specifier.

6/1/2009 13:45:30.5275 -> 5275

6/15/2009 13:45:30.00005 -> (no output)

"FFFFF"

If non-zero, the hundred thousandths of a second in a date and time value.

More information: The "FFFFF" Custom Format Specifier.

6/15/2009 13:45:30.61754 -> 61754

6/15/2009 13:45:30.000005 -> (no output)

"FFFFFF"

If non-zero, the millionths of a second in a date and time value.

More information: The "FFFFFF" Custom Format Specifier.

6/15/2009 13:45:30.617542 -> 617542

6/15/2009 13:45:30.0000005 -> (no output)

"FFFFFFF"

If non-zero, the ten millionths of a second in a date and time value.

More information: The "FFFFFFF" Custom Format Specifier.

6/15/2009 13:45:30.6175425 -> 6175425

6/15/2009 13:45:30.0001150 -> 000115

"g", "gg"

The period or era.

More information: The "g" or "gg" Custom Format Specifier.

6/15/2009 1:45:30 PM -> A.D.

"h"

The hour, using a 12-hour clock from 1 to 12.

More information: The "h" Custom Format Specifier.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 1

"hh"

The hour, using a 12-hour clock from 01 to 12.

More information: The "hh" Custom Format Specifier.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 01

"H"

The hour, using a 24-hour clock from 0 to 23.

More information: The "H" Custom Format Specifier.

6/15/2009 1:45:30 AM -> 1

6/15/2009 1:45:30 PM -> 13

"HH"

The hour, using a 24-hour clock from 00 to 23.

More information: The "HH" Custom Format Specifier.

6/15/2009 1:45:30 AM -> 01

6/15/2009 1:45:30 PM -> 13

"K"

Time zone information.

More information: The "K" Custom Format Specifier.

With DateTime values:

6/15/2009 1:45:30 PM, Kind Unspecified ->

6/15/2009 1:45:30 PM, Kind Utc -> Z

6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings)

With DateTimeOffset values:

6/15/2009 1:45:30 AM -07:00 --> -07:00

6/15/2009 8:45:30 AM +00:00 --> +00:00

"m"

The minute, from 0 through 59.

More information: The "m" Custom Format Specifier.

6/15/2009 1:09:30 AM -> 9

6/15/2009 1:09:30 PM -> 9

"mm"

The minute, from 00 through 59.

More information: The "mm" Custom Format Specifier.

6/15/2009 1:09:30 AM -> 09

6/15/2009 1:09:30 PM -> 09

"M"

The month, from 1 through 12.

More information: The "M" Custom Format Specifier.

6/15/2009 1:45:30 PM -> 6

"MM"

The month, from 01 through 12.

More information: The "MM" Custom Format Specifier.

6/15/2009 1:45:30 PM -> 06

"MMM"

The abbreviated name of the month.

More information: The "MMM" Custom Format Specifier.

6/15/2009 1:45:30 PM -> Jun (en-US)

6/15/2009 1:45:30 PM -> juin (fr-FR)

6/15/2009 1:45:30 PM -> Jun (zu-ZA)

"MMMM"

The full name of the month.

More information: The "MMMM" Custom Format Specifier.

6/15/2009 1:45:30 PM -> June (en-US)

6/15/2009 1:45:30 PM -> juni (da-DK)

6/15/2009 1:45:30 PM -> uJuni (zu-ZA)

"s"

The second, from 0 through 59.

More information: The "s" Custom Format Specifier.

6/15/2009 1:45:09 PM -> 9

"ss"

The second, from 00 through 59.

More information: The "ss" Custom Format Specifier.

6/15/2009 1:45:09 PM -> 09

"t"

The first character of the AM/PM designator.

More information: The "t" Custom Format Specifier.

6/15/2009 1:45:30 PM -> P (en-US)

6/15/2009 1:45:30 PM -> 午 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"tt"

The AM/PM designator.

More information: The "tt" Custom Format Specifier.

6/15/2009 1:45:30 PM -> PM (en-US)

6/15/2009 1:45:30 PM -> 午後 (ja-JP)

6/15/2009 1:45:30 PM -> (fr-FR)

"y"

The year, from 0 to 99.

More information: The "y" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 1

1/1/0900 12:00:00 AM -> 0

1/1/1900 12:00:00 AM -> 0

6/15/2009 1:45:30 PM -> 9

"yy"

The year, from 00 to 99.

More information: The "yy" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 01

1/1/0900 12:00:00 AM -> 00

1/1/1900 12:00:00 AM -> 00

6/15/2009 1:45:30 PM -> 09

"yyy"

The year, with a minimum of three digits.

More information: The "yyy" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 001

1/1/0900 12:00:00 AM -> 900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyy"

The year as a four-digit number.

More information: The "yyyy" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 0001

1/1/0900 12:00:00 AM -> 0900

1/1/1900 12:00:00 AM -> 1900

6/15/2009 1:45:30 PM -> 2009

"yyyyy"

The year as a five-digit number.

More information: The "yyyyy" Custom Format Specifier.

1/1/0001 12:00:00 AM -> 00001

6/15/2009 1:45:30 PM -> 02009

"z"

Hours offset from UTC, with no leading zeros.

More information: The "z" Custom Format Specifier.

6/15/2009 1:45:30 PM -07:00 -> -7

"zz"

Hours offset from UTC, with a leading zero for a single-digit value.

More information: The "zz" Custom Format Specifier.

6/15/2009 1:45:30 PM -07:00 -> -07

"zzz"

Hours and minutes offset from UTC.

More information: The "zzz" Custom Format Specifier.

6/15/2009 1:45:30 PM -07:00 -> -07:00

":"

The time separator.

More information: The ":" Custom Format Specifier.

6/15/2009 1:45:30 PM -> : (en-US)

6/15/2009 1:45:30 PM -> . (it-IT)

6/15/2009 1:45:30 PM -> : (ja-JP)

"/"

The date separator.

More Information: The "/" Custom Format Specifier.

6/15/2009 1:45:30 PM -> / (en-US)

6/15/2009 1:45:30 PM -> - (ar-DZ)

6/15/2009 1:45:30 PM -> . (tr-TR)

"string"

'string'

Literal string delimiter.

6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P

6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P