Format date

[balistikb]

Hello all, I am trying to create a variable in a DTS that is a date. What I am doing is this:
Dim CurDate
CurDate = Date

What this gives me is the full date. What I would like to get is just the month and year like this 04/04
How do I format this?
Thank you

 

[hneal98]

convert the date to text and use the mid function.

 

[balistikb]

Isn't there a way to jus format the date?

 

[hneal98]

You can try the format command from VB, but since this is VB Script, I am not sure if it will work.