date time to date

[Imran Azam]

HI Guys

i have some date with a date field which contians the date and time like the below

01/04/2019 11:26:23

how can i change this to 01/04/2019 and keep it to a date format?

is there a formula that can do this?

 

[alansidman]

Assume data is in A1, then in B1 =Int(A1) or
just format it as short date

 

[Imran Azam]

thanks