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?
Solved
Date format
Best answer by john_armstrong
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.
+11- Nintex Employee
- 143 replies
This can be accomplished via the DateAdd formula function. See also another similar forum dialog here.
- Nintex Employee
- 34 replies
- Answer
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.