AccuZIP Users Community Forum Index AccuZIP Users Community
Tech Support, product information, postal news, and everything else concerning AccuZIP, Inc.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Calculate a date field forward into a new field.

 
Post new topic   Reply to topic    AccuZIP Users Community Forum Index -> AccuZIP6 Commands
View previous topic :: View next topic  
Author Message
Donna
Site Admin


Joined: 18 Mar 2013
Posts: 2731

PostPosted: Fri Oct 16, 2015 9:13 pm    Post subject: Calculate a date field forward into a new field. Reply with quote

Both fields will need to be Date “type” fields not Character fields for this command to calculate your dates forward.

The field type can be changed Edit>Fields.
Make sure the date field in the list and the new date field are both Date "type" fields.

You can add the new field to the list by clicking insert at the bottom of the Edit>Fields screen.
The new field name can be a field name of your preference. Change the (newdatefield) in the command to reflect the name of the field you added.

After you have the new field added. Go to Edit>Command and paste the following into the Command Statement Syntax Area.

Code:
replace all newdatefield with date+15


The +15 will be the amount of days you want to move forward.

The field name (newdatefield) will be the field you added in Edit>Fields for the newly calculated date to be saved in.

Example: An old date field with 06/01/2015 will become 06/16/2015 with this 15 day calculation command.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AccuZIP Users Community Forum Index -> AccuZIP6 Commands All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group