All Collections
Date and Time Formatting
Date and Time Formatting
Patrick avatar
Written by Patrick
Updated over a week ago

Learn how to use Frontly's Date Format features to ensure your blocks are correctly processing date and time related data in your date format.

πŸ’‘ Important Note: When configuring the date formatting of your app, whether you choose default or custom, it is always important to select the format that lines up with your data. Choosing a format that doesn't will create display issues and inconsistencies in your data.

Default Date Formatting

Setting a default date format that will apply to all your 'Date' field types can be done via your app Settings. From there, under your 'General Settings' you can click the

'Edit Date Format' button. Keep in mind if you've created multiple apps, you will need to configure these settings for each of them individually.

From this click, you will be able choose from a predefined list of formats or you can create your own custom ones!

Custom Date Formatting

For users who need a date format that isn't in the default list, you can now define a fully custom format to be used in your app's date-related fields, like calendar, sorting, filtering, etc.

You can set formats like MM-YY-DD or Y-MMMM-D HH:MM, or whatever you want, as long as it's using the supported date syntax.

To learn more about how to construct custom date formats in the correct syntax, click here!

Output Formats

As mentioned at the top of the article, selecting an input format that is congruent with your data is important to ensure your data is processing correctly. However, if you wish to display these values in a different way, you can do so via output formats.

Apart from the General app settings already highlighted, here are the locations in your app where the output formats can be modified:

Data Level

From the 'Data Sources' tab in your dashboard, when you click into any of your data sets, select any fields with a 'Date' component and you can modify their outputs formats from here.

Whenever this data source is used, any output format you set for the fields will override whichever output format you set at the app level.

Table Level

When visualizing your data from a Table block, adjusting the column type to 'Date' will present you the same input/output options.

Click here to learn more about adjusting Table Column Types

Similar to the settings hierarchy at the data level, whatever output format you set here will override what you've selected for the field in your data sources and app settings.

Did this answer your question?