Simplify the formula

[tamilarasu]

Hi,

Can any one simplify the formula please.

VDate is a variable and the values can be 201506

=MakeDate( Left(Purgechar(vDate,Chr(39)),4),Right(Purgechar(vDate,Chr(39)),2))

Thank you.

[tamilarasu]

Hi Ankita,

Your solution also working good. But I am unable to mark two correct answers and i am allowed to mark yours as helpful.

[ankitaag]

Thankyou