Formatting Date and Time on Receipts and Notices

Horizon 7.5.4.1 and later versions allow you to set the date and time field to display the way that you want.

You format the date and time using the Data mask field, but it only specifies how to display the information; it does not hide it.

To set up formatting for the date and time

1 Open the Horizon client and log in.
2 Go to Administration > Table Editor.
3 Select the circ_slip table, and then click OK.
4 Select the Circulation Slip that has the date or time field that you want to format, and then click Edit.

For example, select the payment circulation slip.

5 In the Circulation Slip Field drop-down list, select the Date and Time field to format.
6 In the Data mask field, type the codes for the date or time formatting that you want to display. For example, to display the month abbreviation, type MMM.

To include literal values such as commas, slashes, or dashes, you must include single quotes around the literal text. For example, to include a comma, type ‘,’ as part of the data mask.

Note: If you want a space in the date or time format, type a space between the necessary elements; you do not need to quote them.

You can use any of these formatting codes for the date:

Enter this code

To include this information

d

Specifies to display the day of the month as digits with no leading zero for any single-digit days. For example, “7”.

dd

Specifies to display the day of the month as digits with a leading zero for any single-digit days. For example, “07”.

ddd

Specifies to display the 3-letter abbreviation for the day of the week. For example, “Wed”.

dddd

Specifies to display the full name of the day of the week. For example, “Wednesday”.

M

Specifies to display the month as digits with no leading zero for any single-digit months. For example, “2” for February.

MM

Specifies to display the month as digits with a leading zero for any single-digit months. For example, “02” for February.

MMM

Specifies to display the 3-letter abbreviation for the month. For example, “Feb”.

MMMM

Specifies to display the full name of the month. For example, “February”.

y

Specifies to display the last two digits of the year with no leading zero for any years less than 10. For example, “8” for 2008.

yy

Specifies to display the last two digits of the year with a leading zero for any years less than 10. For example, “08” for 2008.

yyyy

Specifies to display all the digits for the year.

For the Thai Buddhist and Korean calendars that use 5-digit years, you can use this pattern or add another “y” to explicitly specify 5-digit years. However, this 4-digit pattern does show five digits for these two calendars and four digits for all other supported calendars. For example, “2008”.

gg

Specifies to display the period or era string.

This element is ignored if the date to be formatted does not have an associated era or period string.

For example, to get the date string “Wed, Aug 31 1994”, type ddd',' MMM dd yyyy in the Data mask field.

You can use any of these formatting codes for the time:

Enter this code

To include this information

h

Specifies to display the hour with no leading zero for any single-digit hours--based on a 12-hour clock. For example, “2” for 2:00 pm.

hh

Specifies to display the hour with a leading zero for any single-digit hours--based on a 12-hour clock. For example, “02” for 2:00 pm.

H

Specifies to display the hour with no leading zero for any single-digit hours--based on a 24-hour clock. For example, “8” for 8:00 am and “14” for 2:00 pm.

HH

Specifies to display the hour with a leading zero for any single-digit hours--based on a 24-hour clock. For example, “08” for 8:00 am.

m

Specifies to display the minutes with no leading zero for any single-digit minutes. For example, “5” for 5 minutes after the hour.

mm

Specifies to display the minutes with a leading zero for any single-digit minutes. For example, “05” for 5 minutes after the hour.

s

Specifies to display the seconds with no leading zero for any single-digit seconds. For example, “5”.

ss

Specifies to display the seconds with a leading zero for any single-digit seconds. For example, “05”.

t

Specifies to display a 1-character time marker string, such as “A” or “P” for AM or PM.

tt

Specifies to display a 2-character time marker string, such as “AM” or “PM”.

For example, to get the time string “11:29:40 PM”, you type hh’:’mm’:’ss tt in the Data mask field.

Note: You cannot combine the date and time formatting codes in the same field. However, you can put them in two different fields and then place them next to each other on the receipt or notice.

7 Click Save to save your settings, and then click Close to close the window.

 


© 1998-2017 Sirsi Corporation