Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
