get day, month and year from date 1

[arkadia93]

How do you individually get the day, the month and the year from a date, in the format d/m/yyyy, so that day and month could be either 1 character or 2 characters?

 

[snowmantle]

You can use these functions in VBScript:

Day()
Month()
Year()

Eg.

today = Now()
Day(today) = 14
Month(today) = 12
Year(today) = 2006

 

[arkadia93]

I would be trying to get them from a string e.g. '9/12/2006', not from a datetime data type.

 

[snowmantle]

Ok if it is from a string then use the split function.

aryDateSplit = Split("09/12/2006","/")

Split returns an array, so you can get at the split values by doing something like:

strDay = aryDateSplit(0)
strMonth = aryDateSplit(1)
strYear = aryDateSplit(2)

 

[snowmantle]

If you want to convert them to numbers afterwards then check out the function CInt()

 

[arkadia93]

Thanks, I didn't know you could use the Split function in VB, thought it was just C# and Javascript