phtmb Posted May 26, 2002 Posted May 26, 2002 What's the easiest way to create 365 records, each which the date incrementing by 1? Record 1 has date field of 1/1/2003, record 2 has date field 1/2/2003. Want to avoid adding a record at a time and then filling in each date manually. Don't know if this is done with script or field definition using auto enter?
BobWeaver Posted May 26, 2002 Posted May 26, 2002 A script will handle this quite easily: SetField[gDate, Date(1,1,2003)] Set Field [gEndDay, gDate+364] Loop New Record/Request Set Field [Date, gDate] Set Field [gDate, gDate+1] Exit Loop If [gDay > gEndDate] End Loop Field names beginning with "g" are globals. All fields are date fields.
Recommended Posts
This topic is 8553 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now