Skip to main content
Nintex Community Menu Bar

I have an Excel sheet where the date is stipulated as 4/12/20. I need to enter the date as 12/4/20 in SAP. Is there a way to convert the date into the 12/4/20 format?

This can be accomplished via the DateAdd formula function.  See also another similar forum dialog here.  


Hi @Andriesdt 



 



It sounds like you need to change from US date format to an international date format, is that right? 



 



You can do this easily by enabling "Culture support" in your botflow. You should find that in the Botflow settings. Once you have that enabled, you can use the Formula "ConvertDateCulture" to change from the US formatted date into the UK format. This should be enough to change from dd/mm/yyyy to mm/dd/yyyy.



 



Thanks,



John.


Reply