When converting the string date of format ddMMyy the output is in the future. Is there a way to force the century selection to the past?
InputString: 230985
DateOutput: 23/09/2085
Page 1 / 1
Hi
For Changing the date format, you can’t go to future. However you can use string operations to change/force the century date.
An approach is comparing the digits from the year with current year and try to identify if it is bigger or not. It will need additional rules to get a better approach.
1.-You need get the year from you input and assign it to a variable.
2.-Get the last two digits from the current year and assign them to a variable.
3.-Transform both to numbers
4.-Use If action to compare and identify the bigger
5-Add “19” or “20” accordingly
Below i’ve posted details
HTH
Regards
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.