Struggling with Dates in bot using Automation Anywhere Community Edition

This is what the message box returns for Excel[7]
 

@anjelics 

Try to use the Custom Format dd/MM/yyyy when you assign the datatime variable.

HTH

Regards

Thank you for the suggestion, but I still get the same error :/

Have you checked date format showing for the System variable Date? You have to specify the same format.

I'm not quite sure how to do that.
I have built a simpler bot in the interim.

Convert the System variable Date to String and put it in a Message box and see what is the format you are getting there.

For me, the robot works OK¡¡ 🤗

Thanks @Padmakumar

MM/dd/yyyy
dd/MM/yyyy
dd-MM-yyyy

MM-dd-yyyy

I am getting the input date in the above mentioned formats. But I want to convert all the above formats to these format (dd-MMM-yyyy) using Automation Anywhere. I am able to handle one format at a time only, but I want to handle all these above mentioned formats at a time. Is it possible or not? If possible Please suggest me how to do.
Thank you 
Ashok Reddy