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?
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)))
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
