Change Date Format to "dd/mm/yyyy"

[adityo_reksopra]

Good Morning All,

i want to select unique date in a child list, so i created formula like this <<UNIQUE(SELECT([Related cops][Start Period Insurance],TRUE))>>  but it return date format :"mm/dd/yyyy"

i tried to combine the text([date],"dd/mm/yyyy") to change to "dd/mm/yyyy" in the previous formula, and return nothing.

how to combine the formula?

[Suvrutt_Gurjar · Accepted solution]

Please create a VC called say [Start Period Insurance DDMMYY] in your child table Cops with an expression something like 

TEXT([Start Period Insurance],"dd/mm/yyyy")

Now your expression in the template can be

<<UNIQUE(SELECT([Related cops][Start Period Insurance DDMMYYYY],TRUE))>>