hi @Craig1 ,
To format a date-only field to display as "dd/mm/yyyy," you should use the Text function properly. If changing the Text property directly isn't working, consider ensuring that you are using the correct formula and context. Here is how you can adjust the formatting:
- Select the field or control displaying the date.
- Set the Text property using the correct context. For example:
Text(ThisItem.cref3_arrive, "dd/mm/yyyy")
​
If cref3_arrive is the name of the field in the table, make sure it is correctly referenced. The ThisItem context is used to refer to the current item in a gallery or table.
Create a Collection with the Calculated Column:
You can create a collection that includes your calculated column. For example, if you have columns ColumnA and ColumnB and you want to create ColumnC which equals ColumnA - ColumnB, you can do the following:
ClearCollect(
colWithCalculatedColumn,
AddColumns(
yourDataSource,
"ColumnC",
ColumnA - ColumnB
)
)
Set the Items property of your table control to the new collection colWithCalculatedColumn.
