How to convert a time with AM/PM to a datetime var?

Zak_Cooper · October 30, 2018, 9:41am

Hi,

I am having trouble with importing and converting a DateTime from an datatable.

Input format :
03:00 pm

Desired outcome :
15:00:00

Any help would be appreciated

indra · October 30, 2018, 9:56am

@Zak_Cooper You can use this

                                     assign string v1 = DateTime.Now.ToString("HH:mm:ss tt")

Zak_Cooper · October 30, 2018, 11:04am

Thanks indra, worked like a charm

system · October 31, 2018, 11:04am

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

Topic		Replies	Views
Convert datatable string to datetime StudioX studiox , question	7	182	February 9, 2024
I would like to convert the time format from 12 hours to 24 hours Activities activities , question , active_directory	6	3802	March 14, 2022
DateTime column from datatable to DateTime variable Studio question	1	1232	June 9, 2021
Parsing DateTime AM/PM Problem Studio studio , question , activities_panel	3	3547	March 8, 2022
Converting A DateTime String to DateTime regardless of format Activities activities , question , system	4	368	October 6, 2023