Date to 3 columns
I am a summer intern at a marine research society that records Killer Whale sightings and movements. For over 20 years they have been using file maker pro to record the sightings and encounters. I am new to file maker pro but they want to change the date column listed as day/month/year. To 3 seperate columns for year, month, and day. I am using an older version of fmp version 7 to be exact. I was wondering if there is an easy way to do this, instead of retyping the 1400 dates already logged. I am not super good with computers so any help would be appreciated.
Thank you so much!
Define 3 calculation fields. One can use the year function to return the date, another can use the month function to return the month and a third can use the day function to return the day. No retyping needed.