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
Converting dd/mm/yy with Century determination
+4
Userlevel 6
+15
Hi
For Changing the date format, you can’t go to future. However you can use string operations to change/force the century date.
Userlevel 5
+9
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.