98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Word Training and help » Form fields - Date format
Form fields - Date format
Resolved · Urgent Priority · Version 2003
Wed 10 Jun 2009, 16:28Delegate Katie said...
Katie has attended:
No courses
Form fields - Date format
Hi
I have a date form field in my template and set the preference to date only with my own setting of D MMMM YYYY. This works all fine, but if the user puts in for example 2nd June 2009, the field automatically changes to 1 June 2009. This is not right and I would like it to change to 2 June 2009. It also does this when all these other formats are inserted after a number 'rd' 'st' and 'th'
Please could you advise?
Many thanks
Thu 11 Jun 2009, 10:19Trainer Rajeev said...
RE: Form fields - Date format
Dear Katie
Thank you for your question!
Please note that the ordinals don't get recognized if the user inputs the day Month and then the year i.e. 21st June 2009. It reverts back to the first of that month i.e. 01/6/2009.
But if the user inputs the Month first and then the date with eth ordinals it seems to work fine. i.e. August 21st 2009. The date format with eth correct date is displayed i.e. 21 August 2009.
Please find uploaded template file that I was using as test.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Attached files...
Date format.docThu 11 Jun 2009, 10:21Trainer Rajeev said...
RE: Form fields - Date format
Dear Katie
Sorry I didn't realize that I couldn't upload a template file so the file is a normal Word document.!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Thu 11 Jun 2009, 10:24Delegate Katie said...
RE: Form fields - Date format
Hi Rajeev
Many thanks for this. I realise there are probably ways around it but I need to be able to stop people from putting in 21st January 2009 for example and surely if it can work with the month first, there should be a way to make it work the other way?
Katie
Thu 11 Jun 2009, 11:35Trainer Rajeev said...
RE: Form fields - Date format
Dear Katie!!
If I do find a way in the future I'll surely let you know!! :)
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Thu 18 Jun 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Adding date quicklyPress ALT + SHIFT + D and this gives you todays date which defaults as updating automatically. |
