I ask for generic advice on what field format is best to use to store dates in a database (SQLite).
if is a better choice to stored separately year, month and day into 3 separate fields or use one field for a complete date-time group?
I have to store information of this kind:
a person is assigned to a job for a certain day (one day only)
a person is assigned to a job from a day to another day (a range of days)
then i have to query the database for a certain day so to know who is working to a certain job in a specific day.
Well, in the case of ranges of days (for example Mr. Bean works to JOB1 from May/15 to May/20) I have to store one record for each day of the range (6 record in this case) or use only one record with both dates in 2 fields of the same record?
the SQL query should 'ask' who is working on a specific day (even for days in the middle of the ranges).
My doubt is, what's the best way to store ranges of dates (as in the above example), so to be facilitated in the retrieval of those informations.
I'm afraid I'm not been clear, even if I did my best to be, anyway .... any suggestion is welcome..
How to calculate the nearest Sunday?
2012/12/30 (Previous Sunday) 2013/01/03(Today) 2013/01/06(Coming Sunday) Here considering today's date(2013/01/03) the nearest Sunday is coming Sunday(2013/01/06)
How to achieve this using AutoIt? any function close to this?