Jump to content

This topic is 8288 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

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.

This topic is 8288 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.