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?
Best answer by john_armstrong
View original
Userlevel 4
+11
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
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.