Eric, I do not know how this will turn out in this email - but, here are the contents of @User01 (User Variable):
If (Mid$ (DATE,3,3)="JAN","01",If (Mid$(DATE,3,3)="FEB","02",If (Mid$(DATE,3,3)="MAR","03",If (Mid$(DATE,3,3)="APR","04",If (Mid$(DATE,3,3)="MAY","05",If (Mid$(DATE,3,3)="JUN","06",If (Mid$(DATE,3,3)="JUL","07",If (Mid$(DATE,3,3)="AUG","08",If (Mid$(DATE,3,3)="SEP","09",If (Mid$(DATE,3,3)="OCT","10",If (Mid$(DATE,3,3)="NOV","11",If (Mid$(DATE,3,3)="DEC","12")))))))))))) Pse make sure that you copy all of the above as ONLY one-line of data. Here are the contents of @User02 (User Variable): Right$(DATE,4)+...@user01+left$(DATE,2) The above two User Variables are setup so that the DATE variable is available to the Appearance Condition formula as a YYYYMMDD format. THEN - on EACH of the OLD QTH info textboxes - make the Appearance Condition (formula) read as follows: @User02 < "20090821" THEN - on EACH of the NEW QTH info textboes - make the Appearance Condition (formula) read as: @User02 > "20090820" Save the QSL CARD file and you are ready.. 73 Joe wa6axe > From: [email protected] > To: [email protected] > Date: Thu, 26 Nov 2009 23:33:49 -0500 > Subject: [Dxbase] QSL Card Design - Test for Previous Date? > > Using the QSL card design module, does anyone know if it is possible to test > for a date previous to a certain date or do I have to use the date range > condition? > > Reason, we moved to a new QTH in a different county, grid square and Town on > August 21rst of this year. For the cards prior to that date I wish to > indicate the old county, grid and town. Cards from here on will use my new > QTH details. > > I don't wish to reinvent 'the wheel' if someone has already wrote a > conditional test for dates. > > TNX, > Eric - VE3GSI > Read Ontario > > > ______________________________________________________________ > Dxbase mailing list > Home: http://mailman.qth.net/mailman/listinfo/dxbase > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:[email protected] > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html _________________________________________________________________ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141665/direct/01/ ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
