Time Format constants

Can be used in the property formulas to format a time or datetime field (see Time Properties).

Time Type constants

Can be used in the property formula "Time Type" to define the type of a time or datetime field.

Constant	Value	Type	Example
longtimeformat	0	System Default Long Format	"9:56:46 AM CET"
mediumtimeformat	3	System Default Medium Format	"9:56:46 AM"
shorttimeformat	1	System Default Short Format	"9:56 AM"
usecustomformat	2	Custom Format	Allows you to set the format properties yourself.

Can be used in the property formula "Hour" to define the number format of the hour numeral.

Constant	Value	Format	Example
numerichour	0	1	"4:08:00"
leadingzerohour	1	01	"04:08:00"
nohour	2	None	"08:00"

Can be used in the property formula "Minute" to define the number format of the minute numeral.

Constant	Value	Format	Example
numericminute	0	1	"04:8:00"
leadingzerominute	1	01	"04:08:00"
nominute	2	None	"04:00"

Can be used in the property formula "Second" to define the number format of the second numeral.

Constant	Value	Format	Example
numericsecond	0	1	"04:08:0"
leadingzerosecond	1	01	"04:08:00"
nosecond	2	None	"04:08"

Can be used in the property formula "Base" to define if the time will be displayed in 12h or 24h format.

Constant	Value	Format	Example
twelvehour	0	12h	"02:08:00 pm"
twentyfourhour	1	24h	"14:08:00"

Can be used in the property formula "Position" to define the position of the am/pm symbol.

Constant	Value	Example
ampmbefore	0	"pm 02:08"
ampmafter	0	"02:08 pm"