updating Date with strings

[Harold_Timmis]

Ok what I am trying to do is update my date with three string combo boxes.  I am using a time Stamp to two string indecators for my current date and now the user has the option of adding the expiration date they can add months to the current date or days and even hours

how would I do this?

here is my current code: 

[jon_mcbee]

Using month as an amount of time to add in order to calc the exp date doesnt make sense because a month can be 28,29,30,31 days long.  Are you sure you want to do it this way?  How do you want to handle daylight savings and leap years?

Message Edited by jmcbee on 04-08-2009 02:37 PM

Message Edited by jmcbee on 04-08-2009 02:38 PM

[nathand]

Something like this should work.  No need to worry about the number of days in each month, just let the computer handle it.  You need to copy the hours through in the for loop to avoid losing or gaining an hour when daylight savings time starts and ends.

 

Message Edited by nathand on 04-08-2009 04:59 PM

[jon_mcbee · Accepted solution]

Here is an example, let me know if this works for you.  (Nathand posted while I was working that example up, it looks like his is the same as mine if not better for the daylight savings handling).

Message Edited by jmcbee on 04-08-2009 03:04 PM

[nathand]

Jmcbee - I don't think your approach handles year boundaries well (if I put in more months than the end of the year, I get a date in 1903).  On the other hand it seems to work fine with adding 366 days.  The for loop in my approach is unecessary, the right way to handle the year problem is probably this:

Message Edited by nathand on 04-09-2009 10:13 AM

[jon_mcbee]

I saw that problem as well after I had posted.  I didn't test the boundry conditions before posting but I figured that between your post and mine that the poster would get the idea of how to approach the problem.