It's the litte details that trip us up. :smileywink:
I spotted this script step: Set Variable [ $Date; Value:"Date" ]
Notice the quotes. You are storing the word date in the variable $Date--not the contents of a field named date--which is what I assume you meant to do here.
Thus, Set Field [ Days:: Dates; $Date ] is storing this same word into the Days:: Dates field instead of a date value.
Replace "Date" with a reference to the field, presumably the input field you designated in your custom dialog, and it should work for you.
PS. To eliminate the pesky emoticons from your post, insert a space after the colon. If you see an emoticon after you post a message, you can use the edit option from the options menu just above the Kudos control to edit a message after you have posted it.
Oh dear dear dear what ever will i do...
my god... what a head ache! i have sat with this for about 3 hours now and i know what i want to do but not why it wont work. I have a problem the script i entered creates new records but i do not know if it populates them as the script wont end once i have started it - it just carries on popping up and i have have to force quit fm to stop it. therefor it is not creating the records for the whole year but rather record by record.
i tried tweaking around as you have explained but to no avail.
please would you look at the mans original script which was for fm 7/8 and help pin point what i have missed in trying to update it to fm 10.
This expression looks a bit odd:
Exit Loop If [ Year(Days:: Dates + 1) = Year($Date) + 1 ]
If Days:: Dates were to store the date 5/1/2009 (MM/DD/YYYY), Year(Days:: Dates + 1) = Year ( 5/2/2009 ) = 2009
In otherwords Days:: Dates + 1 is adding one day to this date and that may not be what you want here.
If that's not the issue:
You need to post the subscript as well as the script. There's no way to tell from your first script how the script "Generate Days" is modifying the data. Assuming you've modified your script as I suggested, you should post the updated version of that script also.