Solved: Change Date Format to "dd/mm/yyyy" - Page 2

adityo_reksopra · 09-27-2022 08:15 PM

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

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))>>

View solution in original post