Convert timestamp with am/pm in field to date


we have a field named 'timestamp' with the format : "12/09/2018 01:02:10 AM" or " 01/05/2018 05:04:01 PM"

how to convert it to date format ?

i don't know how to delete 'AM' or 'PM' to real time...
thks for help


found ... need to add aa to match filter :wink:

but i only see am time not pm time

found. prefer use hh instead of HH

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.