Hi folks,
If am calling all the dates stored in a database (in the form start_day, start_number, start_month, start_year). I need to convert each into timestamp format and also do the same for their end date (end_day, end_number, end_month, end_year). Then I need to work out the difference between the two.
The reason I am doing this is because I have a form where dates can be added to the database in the above format but must not match or fall between dates already in the database. I will work out the difference between the timestamps of the new dates and that will tell me if it's ok to add or if it clashes with another date.
But what is the best way to call from the database and convert to timestamp given that the start date is called from four fields and the same goes for the end date?
