Personal tools
You are here: Home / How to / Format date field values

Format date field values

How to use Python date formatting.

The Python date format

When you add a Date field to a Plomino form, the values entered in this field are displayed that way:

2010/03/16

It corresponds to the default date format used in Plomino: %Y/%m/%d

The Python language allows to display dates using those kind of formatting strings:

  • %Y is the year
  • %m is the month as decimal number
  • %d is the day of the mont as decimal number
  • %H is the hour
  • %M is the minute

All the details can be found in the Python documentation.

Where to set your date format in Plomino ?

If you need a different format, there are several ways to change it.

First, you can change the default date format for the entire database using the "Date/time format" parameter in the database parameters (see an example).

Secondly, you can set a format specifically for a given field using the Format parameter in the field's Settings tab (see an example).

And thirdly, you can use the DateToString function in a any Plomino formula (here an example in a column)

Document Actions