Creating your own modified DATE Format - by WA6AXE


Example : 05/30/04


The DATE format in the Pending Labels Database and the
Reports Wizard database is programmed as dd mmm yyyy -
which for the example desired above would be 30 MAY 2004.

NOTE: The DATE can not be changed within the Pending Labels Database or
the Reports Wizard Database. So, if you wanted to have a totally
different Date Field APPEARANCE on your Labels/QSL Cards/Reports,
one method you CAN use is as follows (for the desired 05/30/04 format):

Please NOTE: You can modify these examples to obtain whatever
particular FORMAT you might want. In the case we are talking only
about the desired 05/30/04 format for 30 MAY 2004.


The following may seem to be very involved. BUT,
you will achieve the Date Format that you want!



Since the "desired" new DATE format is to be MM/DD/YY - and - since
the default DATE is DD mmm YYYY, we first have to "convert" the MONTH
NAME into a 2-digit numeric. This will be done with a "formula"
that converts EACH month's name. The following is the FULL example of
the formula for all 12 months:

NOTE: ALL of the following information is ALL ON ONE LINE.
I only split-it-up for the ease of viewing.



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"))))))))))))



Next, we want the DD (DAY) .. The formula is:



Left$(DATE,2)



And, finally, we want the YY (YEAR) .. The formula is:



Right$(DATE,2)



NOW that we have the individual segments of the desired DATE format,
and we want the MM/DD/YY to show the / (slash) between each segment,
then the COMPLETE formula for the ENTIRE new DATE format is:



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"))))))))))))
+"/"+Left$(DATE,2)+"/"+Right$(DATE,2)