First, I hope you had a very enjoyable Holiday, this might be the last post for this year! Here's to a prosperous 2007!
If you're a user of Groups in GoldMine you'll find this a very handy tip. Groups, unlike filters or SQL Queries are static, meaning they represent the database when the group was created, a snap-shot, if you will, of the database at a particular point in time.
(For more information on the differences between Filters, Group, and SQL Queries check out this posting: http://goldmineblog.typepad.com/the_goldmine_blog/2006/10/filters_groups_.html)
Since groups are static I find it convenient to 'Date Stamp' the group so I know when it was created. To do this we can use the 'Code' field for a group.
To make this process even easier we can add a dBASE macro to insert the data automatically for us. The value should be:
~date()
That code will automatically insert today's date into the field! Neat eh? The Code field is limited to 8 characters so we have to stick with the DD/MM/YY format.
If, when you use this macro, you get '12/26/20' for example you'll need to change your Window's short date setting to use the DD/MM/YY format. This can be done in the Windows Control Panel under 'Regional and Language Options'. Once in that Control Panel click 'Customize' then change the short date setting under the Date tab.
Get notified of the newest Blog postings as they happen!
Go to: http://www.thegmblog.com/notify and fill out the form. Whenever I update the Blog you'll be notified so you can check out the new post.