Creating your own DATE Format - by WA6AXE




The DATE format in the Pending Labels Database and the Reports Wizard database
is programmed as dd mmm yyyy.
And, it 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, you CAN do it as follows:

Please NOTE: You can modify these examples to obtain whatever particular FORMAT you might want.


I will provide two different examples:

(1) If you want the DATE Field to look like ---> 1999 JAN 08,
when you go into the Label Designer Module and make the DATE Field,
"instead" of just programming the variable DATE, you would program the
Properties of the Date Field as:

Right$(DATE,4)+" "+Mid$(DATE,3,3)+" "+Left$(DATE,2)


(2) If you want the DATE Field to look like ---> 1999 01 08,
when you go into the Label Designer Module and make the DATE Field,
"instead" of just programming the variable DATE, you would program the
Properties of the Date Field as:

(Right$(DATE,4)+" "+If(Mid$(DATE,3,3)="JAN" ,"01" ,"01")+" "+Left$(DATE,2))

-- and --

you would program the Appearance Condition of that Date Field as:

Mid$(DATE,3,3)="JAN"

Now, that takes care of the month of January. Then you would INSERT another
DATE Text Box Field (right on top of the previous DATE Field), but in the Properties,
you would change the "JAN" to "FEB", and also change the "01" ,"01" to "02" ,"02" ...
and Appearance Condition of this Text Box would be "FEB" vice "JAN".

You would do this same procedure for EACH MONTH of the calendar.
This may seem to be very involved; BUT, you will achieve the Date Format that you want!