By using a transaction saved search we can set the Date Created to a specified Date format. For example, if the Date format of an account is MM/DD/YYYY and of another account is DD/MM/YYYY. In both these cases we can set to a specified format of Date as we required.
Under the Result tab give the Formula (Text ) as shown below
formula: “TO_CHAR({datecreated}, ‘MM/DD/YYYY HH12:MI PM’)”
The result will be like
Here the Date Created is 29/06/2023 [DD/MM/YYYY]
This is converted to the format in Formula ( Text ) as 06/29/2023 [MM/DD/YYYY]