How to convert multiple fields from "2022-02-02" to "dd/mm/yyyy" format?

[Kavya132017]

How to convert multiple fields from "2022-02-02" to "dd/mm/yyyy" format?

multi field formula is giving nulls

[binu_acs · Accepted solution]

@Kavya132017 The DateTimeFormat function can convert the Date field into the required format

DateTimeFormat([Date],'%d/%m/%Y')

[ShankerV · Accepted solution]

Hi @Kavya132017 

One way of doing this.

datetimeformat([Field1],"%d/%m/%Y")

Many thanks

Shanker V

[Kavya132017]

How can we do it for multiple fields at once?

[ShankerV]

Hi @Kavya132017 

We need to use multi filed formula tool.

Many thanks

Shanker V

[ShankerV]

Hi @Kavya132017 

If it needs to be over written in the same field.

Many thanks

Shanker V

[Kavya132017]

Thank you Shanker.It worked

[Kavya132017]

Thank you binuacs