Recently we found something weird with the new Date() function.
Customer supplied data in UK format, DD/MM/YYYY
the ori JS does not support DD/MM/YYYY so that it should show Invalid Date when you call new Date();
However when you call new Date() in designer which will treat 26 as month and automatically calculate to year.
That especially confused people if they use date.getMonth() only
Both 26/02/2022 and 02/26/2022 are showing Month is Feb, so that people may think new Date() is working fine with UK format as well
So any particular reason why new Date() is doing an incorrect conversion automatically when date format is wrong in Designer? Or is there any special way to use new Date() in Designer with UK format?