Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thankyou