I rarely used any of the Fill commands in Pan 6, but I have a need for it as I adapt Pan 6 databases to Pan X. But I’m a little lost as to whether it will do the task I need it to. I miss the access to this in a Pan X menu, it looks like I’ll have to write a procedure. Please correct me if I missed something.
I have a database that has a date field that is, unfortunately, merely a text field with a date in MM/DD/YY format. I want to be able to sort my data by date, but this format isn’t going to do it. I have added a field of type Date to hold a date( conversion to a real date value so I can sort on it. Can I set up a FormulaFill (or maybe there’s a better command) that will set each new date field to the date( value of the text date in the same record for all records in one go? Or do I have to write a loop that deals with one record at a time, not needing to use a Fill at all? The documentation for FormulaFill seems to leave this question unanswered.