Extract date from a string

HCL Domino Domino Forum
1

Hello ,

Can you please let me know how to extract date from a string for example like this “Signed as passed by… Pinky Mathur on …23/07/2001 09:38:16” for each of the documents that have status closed.Any help would be greatly appreciated.Thanks in Advance.Please note that the date needs to be known for already existing documents as well.

2

Subject: manually

Hi,

first you have to find a structual way to identify where the date is in the string

string := “Signed as passed by… Pinky Mathur on …23/07/2001 09:38:16”

As you can see, the last part of the string contains the date. the last 19 characters to be exact.

date_string := @right(string, 19)

this will return “23/07/2001 09:38:16” as a string.

now simply convert use @TextToTime:

date := @TextToTime(date_string)

now you have the date as an actual date object.