Calendar, database or other?

[French_gal]

I`m creating a calendar as well as a address book for my project. now what i can`t decide is whether or not i should use a database with access for my calendar. It would make loading and saving easier since i am uncompfertable wiht many of hte other ways i know how. I`m just curious if anyone forsees in problems with it

i was going to use the date feild as the primary key,
the date would be changed into my own format thought.. my original thought was calendar1.day + (calendar1.month*100) so

eg. jan. 1 whoudl be 101
and so on...

so my question is, is their a problem with doing this i dont` see, or does anyone know an easier way to change the date into an exseptable format?

Thanks

[mendhak]

Calendar as database. OK
Your own format. Not OK. Confusing.


What exact problem do YOU see with using the normal form for the date?

[Hack]

In addition to mendhak's question, I'd like to know what you consider to be an "exseptable format"?

[French_gal]

i dont`know
to be honest that thought never crossed my mine.. like dd/mm/yy?

arh.. sometimes i don`t think of the obvious
thanks

[mendhak]

Originally posted by French_gal
i dont`know
to be honest that thought never crossed my mine.. like dd/mm/yy?

arh.. sometimes i don`t think of the obvious
thanks

Umm... OK... what just happened?

[Hack]

Originally posted by French_gal
to be honest that thought never crossed my mine.. like dd/mm/yy

Ok. Cool. Then VB's Format Command would probably handle the job nicely.

How will you be storing your dates in the Db table? This is important, because you will be getting them out, the same way you put them in. So, in order to use the Format command, we need to know what format they are in before putting them in the mm/dd/yyyy format.