Convert worded date/time string to datetime

Vicky_Fegan · March 30, 2021, 3:35pm

Hi. I have a string variable documentDate. This is ‘3 December 2020 14:15:16’.

How do i convert that to a datetime variable?
Thanks

prasath17 · March 30, 2021, 3:44pm

@Vicky_Fegan - You always gets “This is” before the date??

Vicky_Fegan · March 30, 2021, 3:45pm

No just

3 December 2020 14:15:16

prasath17 · March 30, 2021, 3:46pm

@Vicky_Fegan - Try this…

or this…

system · April 2, 2021, 3:47pm

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

Topic		Replies	Views
Converting worded date (string) to date Help activities , string , question , data_manipulation	13	1352	January 12, 2020
Excel string to date Activities datatable , excel	4	277	February 3, 2024
Convert a string to Date format Activities excel , activities , question	10	9267	January 8, 2022
Convert a string to Date time variable Help excel , activities	9	2752	October 3, 2019
Extract datetime variable from a string, "20200408045500" Academy Feedback excel , question	6	2208	April 11, 2020