Formatting date fields in a summary table means that given a data set in one table (default or pre-filled) that you have to fill out, you want the summary table to show a custom format of the date.
To start, navigate your cursor to the left tab and choose either 'Prefilled' or 'Default' Table for your data table (Table 1). Input your desired number of columns or rows. Drop a 'Prefilled' table as your summary table (Table 2).
In your display cell in Table 2, use the formula to display a custom date format:
=TEXT(Source_Table!Source_Cell, Format_Text)
Note: Since the summary table is in another table, we have to make sure to source the data table.
where:
Source_Table - is your data table (Table 1)
Source_Cell - is your source cell from the data table (Table 1)
Format_Text - the custom text format you want the text to appear
There are some common Format_Text you can go about:
DD/MM/YYYY - 31/12/2024
MM/DD/YYYY - 12/31/2024
DD-MM-YYYY - 31/12/2024
MM-DD-YYYY - 12/31/2024
YYYY-MM-DD - 2024-12-31
The basic rules are just:
DD for two units of days
MM for two units of months
YY for two units of years
YYYY for four units of years
DDD for three-letter worded day (Mon, Tue, Wed, Thu, Fri, and Sat)
DDDD for full letter worded day (Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday)
For example:
Given that you have an Equipment Checklist Log, and you want to display the first time they had an inspection with the equipment. Simply copy the date in Table 1 to a cell in the summary table (Table 2) but in a custom format in DDD, MMM DD, YYYY.
Given that,
Table 1 A1 - the cell that contains the date of the first log
Table 2 B1 - the display cell (Formula field)
Use the formula in Table 2 cell B1,
=TEXT(Table1!A1, "MM/DD/YY")