Calculate dates

   Hi all,

 I'm hoping one of the script gurus can help me with 2 problems that have been frustrating me. The first is that I can't figure out the code to produce a column in a scan that will show me the date 4 days before the scan date. For example, if I start a scan on 6/2, I would like to produce a column using bullscript that says shows 2/2. The built in scan criteria dialogue doesn't work if you choose to display date minus 4 days, you get an error message, so it needs to be done with bullscript.

The second thing that I would like to do is hide columns that I don't need to see. This helps to keep a spreadsheet smaller.

Any help would be much appreciated.

Graham

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
G-fer Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 26 Jan 2021 Posts: 1	Post Options Post Reply Quote G-fer Report Post Quote Reply Topic: Calculate dates Posted: 07 Feb 2021 at 1:50pm
	Hi all, I'm hoping one of the script gurus can help me with 2 problems that have been frustrating me. The first is that I can't figure out the code to produce a column in a scan that will show me the date 4 days before the scan date. For example, if I start a scan on 6/2, I would like to produce a column using bullscript that says shows 2/2. The built in scan criteria dialogue doesn't work if you choose to display date minus 4 days, you get an error message, so it needs to be done with bullscript. The second thing that I would like to do is hide columns that I don't need to see. This helps to keep a spreadsheet smaller. Any help would be much appreciated. Graham