Function to extract Date from String

**SAI2** · 09-17-2018, 03:45 AM

Hi,

I am trying to do a function that extracts a date from the end of a string.

This date may have multiple formats
d-m
dd-m
d/m
d/m/yy
mmmyy
etc

I have tried the below but does not work.

Please Login or Register  to view this content.

Can someone help?

Thanks and regards,

SAI

**Kaper** · 09-17-2018, 05:16 AM

The key poitnt is that already in first loop execution you do:

Please Login or Register  to view this content.

so strInput becomes rightmost character of input string.
And of course then it never can get any longer.

Try:

Please Login or Register  to view this content.

**SAI2** · 09-17-2018, 05:53 PM

Thanks for advice and answer,
still not working though.

As suggested, I have attached a spreadsheet with examples, desired results, and current results.

Regards,
SAI

**jindon** · 09-17-2018, 08:24 PM

Try

Please Login or Register  to view this content.

**SAI2** · 09-17-2018, 08:35 PM

Many thanks,
works fine.

S

Function to extract Date from String

LinkBack

Thread Tools

Rate This Thread

Display

Function to extract Date from String

Re: Function to extract Date from String

Re: Function to extract Date from String

Re: Function to extract Date from String

Re: Function to extract Date from String

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How can I extract a date from a string?

VBA to extract date from string

[SOLVED] Extract a date from a string

Extract date from string

Function to extract text in a string

problem with len() function to extract date from string

extract date from string

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions