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 ?
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
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
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
