Need Help to parse date for desision making.

I collect data from third party application using SOAP. This data consists of values and dates of associated data. I can gather the data with out any problem. Based on the date gathered, i need to decide which excel spread sheet to use, IE jan, feb etc... and which column to use for the many data items. All this revolves around the date from the third party that is gathered.

Can someone show me how to parse out the month, or day to a new variable(s) so i can use them to make these decisions?

well im not sure if the date that your dealing with is the same, but if you want the month/day/whatever of NOW or a date in the same format, just go
Month(Now) or Day(Now) or Minute(Now)...exc, if you just do Now you'll get the full date and you can use that in your program to see if how the dates your dealing with and the Now date is in the same format.

Hope that helps.

A Quick Example to display the current...umm...howabout Hour and Minute time

Private Sub Timer1_Timer()
If Hour(Now) <= 12 Then
lblTime.Caption = Hour(Now) & ":" & Minute(Now) & " AM"
ElseIf Hour(Now) > 12 Then
lblTime.Caption = (Hour(Now) - 12) & ":" & Minute(Now) & " PM"
End If
End Sub

Welcome to DEVPPL gregbems

it would be better if you could say in what format do you get the date there are functions in vb to add dates i.e you could add certain no of days and calculate what the resulting day and month would be

this link would help you a lot in understanding about the inbuilt functions not only date but everything

http://www.int.gu.edu.au/courses/3008in ... Syntax.htm

if you want to read only about dates this is it

http://www.int.gu.edu.au/courses/3008in ... #Heading31

you will get everything about dates here