I Want to convert this “05SEP” String into “dd-MM-yyyy” format that is 05-09-2021(Current year) how to do it??? Help me
CDate("05SEP"&"2021").toString("dd-MM-yyyy")
CDate(YourStringVar & "2021").toString("dd-MM-yyyy")
kindly note:
will return not the mentioned one date 5th sep 2021
I am having this “05SEP” string value in a variable shall use variable in this expression
I want to dynamic year, If next year comes means I would mention 2022, is their any expression to mention the currrent year
just end the word year with the r in your code
what modification I have to do it in this expression
It should be like this.
CDate(Extracted_Estimated_Date&Now.Year.ToString).ToString("dd-MM-yyyy")
Here, Extracted_Estimated_Date variable of type String and it holds the Date and Month.
Showing error, ‘(’ expected showing like this
CDate(Extracted_Estimated_Date&Now.Year.ToString).ToString(“dd-MM-yyyy”)
Like this only I have mentioned
Thanks Bro Have Got the Expected Output