Extract date from notes

[anjali0108]

Hi all,

I have a string field(notes) that has dates in it.

I want to extract the dates or max date from it for further calculations.

How can I do that?

Thanks in advance.

[sunny_talwar]

What does your string look like? Few possible sample strings?

[anjali0108]

Hi sunny,

Actually,I myself did not receive the data yet but got the requirement so wanted to know if its feasible.

Will share sample data asap once I get it from the account team.

Thanks.

[Sergey_Shuklin]

Hello, Anjali!

If your string consist of some separators which are enclose the date you can use some string function for exctracting the date:

TextBetween - if your date like <01.01.2017>

Subfield - if you have specified separator

KeepChar - if your date is a number 48523 and there is no other numbers in a string

[sunny_talwar]

Sound good... unless we know the specific text, it might be difficult to give a generic solution which works for all scenarios

[Sergey_Shuklin]

Yeah, it's quite interesting to speculate, but w/o samples it worth nothing =D ... Maybe there is a hint or a clue how possibly the string may looks like?