Dear
I have a problem with the format in the pivot table made from a table made by Table Builder.
I am unable to change the format which is day/month to day/month/year, although I have set this in the field settings of the field.
Dear
I have a problem with the format in the pivot table made from a table made by Table Builder.
I am unable to change the format which is day/month to day/month/year, although I have set this in the field settings of the field.
Hi Karlos.
Perhaps someone else has seen this, but I haven't. You might try this as a workaround: in your table builder, choose "Formula" to add a bespoke formula. Then, in the formula bar, enter something like TEXT([@[Posting Date]],"DD/MM/YYYY"
Obviously, change [@[Posting Date]] to whatever field you have currently received with a date field.