Mid and Value formula

Peter Smith

ricki

First, i think the field you have the date time in ("Meeting type AGM/SGM", ) needs to be text. The date field seems to remove any time

 

Also, what format do you want the date in in the new field?

ricki

 

I think that if you make ([Meeting type AGM/SGM] a text field

and you have a new date field, the following formula in the new date field should work

 

The corrections i made over your original formula is that i swapped the month and date fields in the formula. You also had an extra, unballanced ) at the end of your formula which i removed

 

=DATE(VALUE(MID([Meeting type AGM/SGM]3, 7, 4)), VALUE(MID([Meeting type AGM/SGM]3, 4, 2)), VALUE(MID([Meeting type AGM/SGM]3, 1, 2)))

Peter Smith

Hi, Ricki:

 

Really appreciate for your help. Formula is work. You are right,I  should use date column. By the way,  are you freelancer? How can I reach you?  I have small project and willing to pay. You can reach me at dragonsneakerbc@gmail.com

 

Thanks very much