Table look up not behaving as expected

[ppe_office]

what am i doing wrong

[Jean_Pierre_Traets]

Dear @ppe_office,

Welcome to the community

Please could you be more specific where you see something going wrong?

[ppe_office]

in contacts table , consultation column, row #6 date format has changed.

[Jean_Pierre_Traets]

Dear @ppe_office

In the consultation table the column “type consult” should contain the following formula:

Concatenate(Format("{1} {2}, {3}", thisRow.[date of consult].MonthName(), thisRow.[date of consult].Day(), thisRow.[date of consult].Year()), "  " ,thisRow.contacts)

The formula “format” is assuring that the layout is consequent executed in the way you write in the syntax.

This is the source where I have learned it in the past:

Custom date format

Assuming “custom” would mean none of the inbuilt ones, you could use Format

[ppe_office]

@Jean_Pierre_Traets

Concatenate(Format("{1} {2}, {3}", thisRow.[date of consult].MonthName(), thisRow.[date of consult].Day(), thisRow.[date of consult].Year()), " " ,thisRow.contacts)

thank you love it button