[RESOLVED] Problem with date difference

[velkalai]

Hi All,

I've a vb3 application. I need to modify the application to do the below.

For example,
date1, date2, date3 are the calculation dates. If my transaction has a date say trdate, then if the trdate is equal to date1, then add the amount, if it's equal to date2, then add the amount with that on date2 and so on.

My problem is this date1, date2, date3 can only be valid business dates, i.e. no sat,sun or holidays and if the trdate is equal to date1 - add the amount with that on date1, if it's greater than date1 and lesser than date2 and if the difference between trdate and date2 is just one day. i.e. one holiday after date1, then add the amount with date2, if it's greater than 1 i.e. 2 or more holidays then add with that in date3.

Hope I've not confused.. Any suggestions to find the date difference is much appreciated...

Thanks a lot.

[Siddharth Rout]

Here is a start

1) Use the Weekday(). This function returns a number from 1 to 7 indicating the day of the week for a given date, where 1 is Sunday and 7 is Saturday.

2) Now as for holidays are concerned... What holidays are you considering? US holidays, UK holidays or some other? See this link on how to determine any holiday?
http://www.tek-tips.com/faqs.cfm?fid=5185

3) To compare dates use the DateDiff(). The DateDiff function returns a long integer specifying the number of time intervals between two specified dates.

4) Once you have these in place then I don't think you will have a problem with the rest of the code but if you still get stuck then do post the code that you have tried and we will definitely help you...

[RhinoBull]

@koolsid:

not totally sure about the Weekday but DateDiff was definitely not available in VB3 - it first appeared in VB6.

[Siddharth Rout]

Ah My bad!!! missed that part...

that means more coding

[RhinoBull]

I take it back - just ran VB3 and guess what: both functions were available.
Arghhhhh... I guess last 3 replies (including this one) can be deleted.

[Siddharth Rout]

I take it back - just ran VB3 and guess what: both functions were available.
Arghhhhh... I guess last 3 replies (including this one) can be deleted.

Where did you get VB3 from?????

No I guess it is no point deleting these posts as it vouches that these functions do work in vb3

[RhinoBull]

I downloaded it from MSDN but still have on dozen of floppies (preserving the history ).

[velkalai]

Hi,
I'm able to solve this using datediff.
Thanks a lot for the suggestions.

[Siddharth Rout]

Great. If your query is solved then do remember to mark this thread resolved. There is a link in my signature on how to do it