AnsweredAssumed Answered

Capture Date's in 1 Field

Question asked by KAmsinger on Jun 2, 2011
Latest reply on Jun 2, 2011 by philmodjunk


Capture Date's in 1 Field



I have a field that is a drop down calendar. And when I communicate with someone who has a record in my database I put in the date that I sent them an email. If I don't hear back within a certain time period I will email them again and then update the date in the drop down calendar field that I sent the 2nd email.

What I want is in a separate field to list out each date entered into that calendar drop down field in chronological order. So lets say the field capturing the dates is called "Dates Emailed", in this field it would display the past dates entered into the calendar drop down field, which is a separate field from the Dates Emailed field. So every time I change the date in 1 field it captures the date and lists it like this in another field- "Emailed - 6/1/11, Emailed - 6/2/11, Emailed - 6/5/11, and so on... "

Any help with this would be awesome. Oh and I am using FMP Adv 10.