Solved

Date format

  • 21 July 2020
  • 2 replies
  • 14 views

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?

icon

Best answer by john_armstrong 21 August 2020, 22:13

View original

2 replies

Userlevel 4
Badge +11

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

Userlevel 3
Badge +7

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