Time

[ntudev]

How do i get the time out of this date 5/24/2022 12:00:00 AM, i just want the date only 5/24/2022.

[IraWatt]

Hey @ntudev,

Could use the regex tool:

The regex tool lets you give a regex pattern and parse the result to a new column.

Any questions or issues please ask :)
HTH!
Ira

[CarliE]

@ntudev 

To use a formula, you can do the following  -- datetimeformat(DateTimeParse([Field1],'%m/%d/%Y %I:%M:%S %p'),'%m/%d/%Y')

If this solved the issue please mark it as a solution to help other members out!

Thanks

[IraWatt · Accepted solution]

Alternatively you could use the date time tool to convert you text data to a date data type:

[CarliE]

@IraWatt  Did that originally and then consolidated :) Good call out!

[binu_acs]

@ntudev @Another option using string function 

substring([Date], 0, FindString([Date],’ ‘)