nodding dino
Board Regular
- Joined
- Aug 5, 2003
- Messages
- 94
Hey all,
I've spent some time searching through these boards and I've also taken a look at cpearsons site, but can't seem to get this figured out!
I have a userform with two sets of three combo boxes. The first set of boxes is used to capture date number 1 (cmbo 1 = dd combo 2 = mm combo 3 = yyyy) and the second to capture date number two.
I then concatenate the results (adding forward slashes) to give me the 'proper' dates eg 01/01/2005
I am using datediff to compare the number of months between these dates.
If a user enters a date that is prior to the comparison, I get an error.
I thought that if i first converted the dates to julian, I could check to see if the comparison was valid, and, if not, serve an error message.
For some reason, I just can't seem to get my dates converted to julian!
I looked at cpearsons function - but couldn't work out how I was supposed to embed it in my code. So then thought i could use forumlar1c1 and use one of the formulas (found on these boards) to populate an arbitrary cell with the julian value which i could then use to make a comparison. for some reason I can't get this to work either!
can anyone help?
In a nutshell i want to take a date (that is held in a variable in the format 01/01/2005) and convert it into julian.
Thanks so much...!
I've spent some time searching through these boards and I've also taken a look at cpearsons site, but can't seem to get this figured out!
I have a userform with two sets of three combo boxes. The first set of boxes is used to capture date number 1 (cmbo 1 = dd combo 2 = mm combo 3 = yyyy) and the second to capture date number two.
I then concatenate the results (adding forward slashes) to give me the 'proper' dates eg 01/01/2005
I am using datediff to compare the number of months between these dates.
If a user enters a date that is prior to the comparison, I get an error.
I thought that if i first converted the dates to julian, I could check to see if the comparison was valid, and, if not, serve an error message.
For some reason, I just can't seem to get my dates converted to julian!
I looked at cpearsons function - but couldn't work out how I was supposed to embed it in my code. So then thought i could use forumlar1c1 and use one of the formulas (found on these boards) to populate an arbitrary cell with the julian value which i could then use to make a comparison. for some reason I can't get this to work either!
can anyone help?
In a nutshell i want to take a date (that is held in a variable in the format 01/01/2005) and convert it into julian.
Thanks so much...!