Convert Datetime to Date

[User12321]

Hi,

I have a datetime field named Completion time containing value like 10/10/2020 1:23:45 AM.

I only want to get the date in the load.

Can someone help please. Thank you.

[abhijitnalekar · Accepted solution]

Hi @User12321 ,

Please try below

Date(Completion time,'DD-MMM-YYYY')