UserImage.jpg
VR
53Views
14Comments
Solved
Convert text to datetime
Question
Logic

Hi ,

I need to convert the following text to date time :

Text - "8/18/2023 5:36:54 PM"

Converted result - 1900-01-01 00:00:00

I used the following function TextToDateTime().

0
0
07 Sep
Solution

Hey VR,

Use the below logic to covert that text in your server side code :


NewDateTime(

    TextToInteger(Substr(GivenInput, Index(GivenInput,"/",searchFromEnd:True)+1,4 )) 

   ,  

  TextToInteger(Substr(GivenInput,0 , Index(GivenInput,"/"))) 

   ,

    TextToInteger(Substr(GivenInput, Index(GivenInput,"/")+1,Index(GivenInput,"/",searchFromEnd:True)-Index(GivenInput,"/")-1 ))

    , 

   TextToInteger(Substr(GivenInput, Index(GivenInput," ")+1 ,Index(GivenInput,":")-Index(GivenInput," ")-1 ))+    If(Substr(GivenInput,Index(GivenInput," ",searchFromEnd:True)+1,2)="AM",0,12)

    ,

    TextToInteger(Substr(GivenInput, Index(GivenInput,":")+1 ,Index(GivenInput,":", searchFromEnd:True)-Index(GivenInput,":")-1 ))

    , 

   TextToInteger(Substr(GivenInput, Index(GivenInput,":",searchFromEnd:True)+1 ,Index(GivenInput," ", searchFromEnd:True)-Index(GivenInput,":",searchFromEnd:True)-1 ))

)


Note that here GivenInput ="8/18/2023 5:36:54 PM" 


I am giving this after testing. It will definitely work.

Thanks & Regards,

Sudip Pal

See solution in context
3
0
08 Sep

I think that is proper way to convert it on server side and should work fine

0
0
08 Sep

Replying to Jitendra Kumar's comment on 08 Sep 2023 20:20:07

Yes Jitendra.I don't see any other idea to solve .

Thanks,

Sudip Pal

0
0
09 Sep

Hi Sudip Pal,

It works well. But In my case I need to manipulate many records i.e. more than 10k records need to be manipulated. In your solution we have many functions.

Thank you for your suggestion.

0
0
11 Sep

Replying to VR's comment on 11 Sep 2023 10:32:12

Hey VR,

This is the only option available. I think that you will not face any problem with 10k data. Please try and let me know.

Thanks & Regards,

Sudip Pal

1
0
11 Sep
2023-10-21 19-42-11
Tousif Khan
Champion

Hello @Vijay R 

It will return you the default date only because, before conversion, you need to

format the date time in the same way as you are getting the result you can check the format date time function. Also here is the examples that can be convertible to date time


You need to pass the text string in this format

If you dont have the correct format you need to do string manipulation, for that you can use substr() function.

Also I have created a JS based sample that might help you 

https://personal-ejuytnht.outsystemscloud.com/ConvertStringTodate/DateConversion

Thanks

Tousif Khan

ConvertStringTodate.oml
1
0
07 Sep

hi Tousif,

Thanks for your solution, but I need to apply this on server side.

0
0
08 Sep

Hi Pawan,

Thanks , I have checked this link already ,the solution gives 2 ways :

1-method which is marked as solution will convert only date not datetime.

2-method is regex , this regex converts however could not convert to 24 hour format.

I need to convert the text to datetime as 24hour format.

0
0
08 Sep

Hi Vijay R,

To convert the text to date time you have to convert the date of the given string to this format  "2023/18/08  05:36:54" you can use the below JS to convert date format 

JS Code convert Date format 

Input in text/string 

Output in text/string  

var date = $parameters.inpDate;(current format dd/MM/yyyy)

var newdate = date.split("/").reverse().join("-");

$parameters.formatedDate = newdate ;(Convert to yyyy-MM-dd)


AND then you can use textToDatetime function 

Hope this will help you.

Regards


0
0
08 Sep

Hi Asiyah,

Thanks for the suggestion, I am looking to apply at the backend server side.

& I hope your suggestion will work for date conversion, anyway looking to convert to date time.

0
0
08 Sep

Replying to Vijay R's comment on 08 Sep 2023 12:26:13

Could you pls share your OML ,so that i can help you with .

0
0
08 Sep

Hello VR,

If you share your oml it will be much easier to understand and share proper solution to you.

Or at least share your implementation screenshots.

0
0
08 Sep

Please check my OML, i am converting text to datetime format using Javascript.

This might resolve your solution.

sample_test.oml
0
0
08 Sep
Solution

Hey VR,

Use the below logic to covert that text in your server side code :


NewDateTime(

    TextToInteger(Substr(GivenInput, Index(GivenInput,"/",searchFromEnd:True)+1,4 )) 

   ,  

  TextToInteger(Substr(GivenInput,0 , Index(GivenInput,"/"))) 

   ,

    TextToInteger(Substr(GivenInput, Index(GivenInput,"/")+1,Index(GivenInput,"/",searchFromEnd:True)-Index(GivenInput,"/")-1 ))

    , 

   TextToInteger(Substr(GivenInput, Index(GivenInput," ")+1 ,Index(GivenInput,":")-Index(GivenInput," ")-1 ))+    If(Substr(GivenInput,Index(GivenInput," ",searchFromEnd:True)+1,2)="AM",0,12)

    ,

    TextToInteger(Substr(GivenInput, Index(GivenInput,":")+1 ,Index(GivenInput,":", searchFromEnd:True)-Index(GivenInput,":")-1 ))

    , 

   TextToInteger(Substr(GivenInput, Index(GivenInput,":",searchFromEnd:True)+1 ,Index(GivenInput," ", searchFromEnd:True)-Index(GivenInput,":",searchFromEnd:True)-1 ))

)


Note that here GivenInput ="8/18/2023 5:36:54 PM" 


I am giving this after testing. It will definitely work.

Thanks & Regards,

Sudip Pal

3
0
08 Sep

I think that is proper way to convert it on server side and should work fine

0
0
08 Sep

Replying to Jitendra Kumar's comment on 08 Sep 2023 20:20:07

Yes Jitendra.I don't see any other idea to solve .

Thanks,

Sudip Pal

0
0
09 Sep

Hi Sudip Pal,

It works well. But In my case I need to manipulate many records i.e. more than 10k records need to be manipulated. In your solution we have many functions.

Thank you for your suggestion.

0
0
11 Sep

Replying to VR's comment on 11 Sep 2023 10:32:12

Hey VR,

This is the only option available. I think that you will not face any problem with 10k data. Please try and let me know.

Thanks & Regards,

Sudip Pal

1
0
11 Sep
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.