11-13-2008 10:03 AM
I would like a customized date field to hold only MONTH and DATE with no year for annual renewal reporting. I do no and do not want the year field as I will have to roll all customers forward in thousands of records annually.
Currently my Date Field format is set to DD/MM/YYYY and as stated in the ACT help based off of the short date from the Windows regional settings. I'm trying to build a report that sorts on a key field based on Month/Day only.
I have created two fields and still can not get my report to sort appropriately. The second field is character and sorts alphabetically.
1) DD/MM/YYYY (Date)
2) MMM-DD (Character)
11-13-2008 10:22 AM