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 Access Training and help » Date Table
Date Table
Resolved · Low Priority · Version 2003
Mon 8 Sep 2008, 11:25Delegate Tom said...
Tom has attended:
Access Intermediate course
Access Introduction course
Date Table
How do you create a date range table to convert dates to year / month / week ?
Thu 11 Sep 2008, 16:57Trainer Rajeev said...
RE: Date Table
Dear Tom
Thank you for attending Access courses. I hope you enjoyed them and benefited from them.
Can you please provide me with an example with regards to your query.
I was wondering if you are looking for calulation between two dates and tring to get teh results in day, months or Years?
or just to change the format from dd/mm/yy to other formats?
If you plan to calulate days, months or Years then you need to creata query and perform some calculation. In Report you have a function called date Fiff that can give you the result of teh difference between two dates in days , months or Years!!!
If you like to know more about the DateDiff function then please press the reply button and I should be able to demonstrate that!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
Fri 12 Sep 2008, 10:02Delegate Tom said...
RE: Date Table
Thanks Rajeev,
We have sorted out how to convert dates into our relevant year / month / week, but we have come accross a new problem.
Basically, the date that comes accross from our system is DD/MM/YY HH:MM:SS. This then causes us the problem of not being able to convert the date, as we are comparing this to DD/MM/YY.
How do we convert the DD/MM/YY HH:MM:SS into DD/MM/YY - I am assuming we will use a column within a query to do this, but can't see how to do the conversion.
Best regards
Tom
Fri 26 Sep 2008, 11:00Trainer Rajeev said...
RE: Date Table
Dear Tom
Thank you for your response!!
If the data is being imported into Access table you can simply go to the design view of that table and for that field ensure that the Data type is set to Date/Time and most importantly in the format section of the field property simply type dd/mm/yy. This will ensure that the dates will be displayed in the specified format.
I hope this helps.
Please mark this post as resolved if you are satisfied with the reponse!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
Training information:
See also:
|
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. |
Access tip:Pop up propertyIf you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On. |
