Custom date, time and currency formats

If the default date/time and currency symbol formats provided with the document management software does not meet your needs, thay can be customized. Custom date formats can be entered directly in the Custom Format field of the date metadata configuration dialog. Currency symbols can be modified by editing a resource file on the FileHold server. If you are using FileHold version 16.1 or older, you must edit a resource file on the FileHold server to change date/time formats.

It is possible to select date formats that do not include all components of the datetime such as only years, months, or days but this only changes the display of these values. The full date and time is stored in the field regardless of how it is displayed. This is important to know when you are searching for documents with these dates. Also, the user interface does not provide an option to select the time component of the field, so when you choose a specific date it implies all times from the beginning to the end of the day.

Date and time format identifiers

These format identifiers can be used in the Custom Format field of the date metadata configuration dialog or, for older FileHold versions, the resource file. These are standard Microsoft .NET date/time format modifiers.

Format identifierDescriptionExamples
"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

Default currency symbols

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

  • $
  • £
  • €
  • ¥
  • Kr
  • R

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:\Program Files\FileHold Systems\Application Server\LibraryManager\App_GlobalResources.
  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. Recycle the FileHold web site or restart the Web Server (IIS).

Default date and time settings

The following details are provided for users with FileHold version 16.1 or earlier.

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

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:\Program Files\FileHold Systems\Application Server\LibraryManager\App_GlobalResources.
  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.

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

 

Knowledge Base
Free Webinar Free Trial Videos Features
Contact Sales Text +1-604-734-5653 Contact Sales