Convert/Split Excel into dd-mmm-yyyy hh:ss into 2 variables or fields

Callos_James_AU · March 4, 2020, 2:08am

Hello Everyone

Anyone here tried to convert or split a value like this “180620191412” into dd-mmm-yyyy and hh:mm in excel file? Appreciate your help. Thanks guys

Yoichi · March 4, 2020, 2:33am

Hi,

Hope the following sample helps you.

Regards,

lakshman · March 4, 2020, 2:33am

You need to define column in that format in Excel file and then check it once.

Callos_James_AU · March 4, 2020, 4:24am

Hello @Yoichi! Thanks for always answering my query You’re a star!!!

system · March 7, 2020, 4:24am

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

Topic		Replies	Views
How to convert a string in dd/MM/yyyy into MM/dd/yyyy hh:mm:ss in DateTime Format Studio studio , question , tools	2	2854	May 25, 2021
How To Read Data from Excel Column "dd.MM.yyyy HH:mm:ss" and Convert it to Date Format? Help	9	3564	May 8, 2019
How to convert date in column to date format(dd/MM/yyyy) Studio studio , question , workflow_diff	18	796	October 5, 2023
How to convert dd-MMM-yy to yyyy.MM.dd format? Studio studio , question , activities_panel	10	1737	September 20, 2022
How to convert date format in excel from format 3-Nov-17 to 20171103 Help	2	991	November 1, 2018