I have column with data type date format 2020-01-30 15:02:45, i need to convert this into 30/01/2020.
Thank you for your response. This is not working since my data type is DateTime but the screenshot you shared has the data type V_Wstring. Is there any other way to convert this format, please assist.
Hi @troy_mech , try this.
Formula- DateTimeFormat([Field1],"%d/%m/%Y")
Thanks.
You can use a select tool to remove the time, by just changing the data type from DateTime to Date only
You can manage the data type conversion in a formula by creating a new field that is a date and setting it equal to the field having the datetime value. Same as using a SELECT tool but cleaner; especially since you can stack the formulas into the same tool.
