mykal66
05-15-2014, 01:21 AM
Hey everyone
I have used a date picker provided by another user to try and combat format inconsitency when users add a date to a from and at first glance it works brialliantlly.
In testing however i found that depnding on the date that is selected by the user the date copied to the form is either in US or EU format wheich then skews the data when it is copied to the main datasheet.
I've attached a diluted version of the workbook to show what i mean but in essence the date (day) chosen is over 12 e.g. 13 May 2014 the date is copied across to the text box correctly, then over to the datasheet correctly once the form is completed / submitted. If the date (day) chosen by the user is 12 or less e.g. 7 November 2014 the day/months are transposed into the text box and subsequent datasheet.
To throw another spanner in the works which is why i've striggled to try and sort it is that it is random if and when it transposes the dates. I've just done 13 tests on my PC and everyone both dates over 12th and below have worked properly both transposing to th etext box and the datasheet.
THis is not priority as dates are being eneterd manually but if anyone can help that would be great
Thanks
Mykal11691
I have used a date picker provided by another user to try and combat format inconsitency when users add a date to a from and at first glance it works brialliantlly.
In testing however i found that depnding on the date that is selected by the user the date copied to the form is either in US or EU format wheich then skews the data when it is copied to the main datasheet.
I've attached a diluted version of the workbook to show what i mean but in essence the date (day) chosen is over 12 e.g. 13 May 2014 the date is copied across to the text box correctly, then over to the datasheet correctly once the form is completed / submitted. If the date (day) chosen by the user is 12 or less e.g. 7 November 2014 the day/months are transposed into the text box and subsequent datasheet.
To throw another spanner in the works which is why i've striggled to try and sort it is that it is random if and when it transposes the dates. I've just done 13 tests on my PC and everyone both dates over 12th and below have worked properly both transposing to th etext box and the datasheet.
THis is not priority as dates are being eneterd manually but if anyone can help that would be great
Thanks
Mykal11691