Need to add to the year (OpenInsight 16-Bit Specific)
At 21 JUN 2002 09:48:37AM a becker wrote:
Is there anyway without a whole lot of work (programming) that I can take an input date in MM/DD/YYYY format and just add 1 to the YYYY?
The user is entering 25 dates and each date is the same month and day, just the year changes. For example, the first date is 2/15/2002, the 2nd date is 2/15/2003, etc., until all 25 years have been entered.
Is there anyway to programmatically do this?
Thanks
Andy Becker
IL State Lottery
At 21 JUN 2002 10:01AM [email protected] wrote:
There is nothing standard to OI but there are a couple different ways to do it programatically ..
If you are always dealing with years .. simply put in the starting date and then the number of years and build that way.
Or as we handle this we allow the use of +- key. For us we default to today and the user can ++++ to move forward 4 days etc (similar to quick books)
It really depends on your form and process ..
But once again .. there is nothing standard
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 503-639-4240
At 21 JUN 2002 10:18AM jim wrote:
curYear=curDate-4,4 ;* curDate=MM/DD/YYYY
nextYear=curYear + 1
nextDate=curDate
nextDate-4,4=nextYear
At 21 JUN 2002 10:48AM b cameron wrote:
If you know that your date is guaranteed to mm/dd/yyyy
newyr=field(yourdate,"/",3) + 1
At 21 JUN 2002 10:50AM b cameron wrote:
Sorry left off the rest…
newdate=yourdate1,5:"/":newyr
At 21 JUN 2002 12:15PM a becker wrote:
Thanks folks
I was almost ready to make a mountain out of a mole hill.
Andy