cancel
Showing results for 
Search instead for 
Did you mean: 
Andriesdt
Nintex Newbie

Date format

Jump to solution

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?

0 Kudos
Reply
2 Replies
Sasan
Nintex Employee
Nintex Employee

Re: Date format

Jump to solution

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

0 Kudos
Reply
john_armstrong
Nintex Employee
Nintex Employee

Re: Date format

Jump to solution

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.

View solution in original post

0 Kudos
Reply