May 26, 200223 yr 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?
May 26, 200223 yr 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.
Create an account or sign in to comment