|
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.
(1) If you want the DATE Field to look like ---> 1999 JAN 08, Right$(DATE,4)+" "+Mid$(DATE,3,3)+" "+Left$(DATE,2)
(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
You would do this same procedure for EACH MONTH of the calendar. |