J Joelyue Registered User. Local time Tomorrow, 03:21 Joined Mar 16, 2007 Messages 18 May 20, 2008 #1 How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 ..........
How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 ..........
R rockyjr Registered User. Local time Today, 15:21 Joined Mar 12, 2008 Messages 100 May 30, 2008 #2 Joelyue said: How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 .......... Click to expand... I dont know if this is what you are looking for user SETVALUE macro and set the [fieldname] = Now() ie: Item : [fieldname1] Expression : Now() Item : [fieldname2] Expression : Now()+1 Item : [fieldname3] Expression : Now()+2 PS - instead of Now() you can also use Date()...... Now adds the time. Hopes this helps
Joelyue said: How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 .......... Click to expand... I dont know if this is what you are looking for user SETVALUE macro and set the [fieldname] = Now() ie: Item : [fieldname1] Expression : Now() Item : [fieldname2] Expression : Now()+1 Item : [fieldname3] Expression : Now()+2 PS - instead of Now() you can also use Date()...... Now adds the time. Hopes this helps
