Answer the question: Format date
The reader Jacinto put a question here on how to change the format of a date of 12/06/2008 for 2 0 0 8 0 6 1 2, the response as explained in the comments is as simple as a text box with the following expression:
= Format ([date field name], "mm dd yyyy")
and properties of the field put the following words in the input mask: 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0
Pretty simple and easy. Follow the example for download: Format date
Someone can give me a little help to do this work in accessories?
xxx the company rents each place for different types of customers. Rent to clients who seek at every moment the park and looking for a place available. It has 10% of the seats (ie 50, 7 and 3 for each of the types mentioned above) always reserved for clients who are guests of a nearby hotel. It also has some seats reserved for customers who contratualizaram with the company a monthly rental of a place. The company is selling at prices taking into account the following rules:
- Hire per hour for each type of place for guests seeking the park in a "free";
- Hire per hour for each type of place they are a hotel guest;
- Monthly rental for each type of place.
The input of each vehicle is registered in the park when passing the entrance to remove the card (for guests seeking the park in a "free") or passage of a magnetic card (for customers who are guests of the hotel or rental properties monthly).
Whenever a new customer of the hotel you want to use the park is given a magnetic card (which is recorded the date of use of the park) and a place is reserved. A similar procedure is done for customers with monthly contracts. The difference lies in the processes in the kinds of prices to be charged to each customer type.
In every moment the organization has to know a variety of information relating to the management of the park, among others, include:
- Listing of free seats;
- Listing free places by type of customer;
- Listing periods used by client;
- List of customers who had in the month / year greater use of the park
I would appreciate the help,
Greetings