IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
This can not be disabled, however there are a number of alternatives which can be implemented to retain the original formatting of the date/time data.
For example if a user has formatted their Excel data in the following way:
dd/mm/yyyy hh:mm == 20/07/1983 12:30
When read into SilkTest this would be re-formatted to: 1983-07-20 12:30
This can be over come by either of the following methods:
Utilising this function we can re-format the date into the users desired type, for example:
FormatDateTime (laData, "dd/mm/yyyy hh:mm")
This can be utilised to fully preserve the data formatting:
Copy the data from Excel to the clipboard and then to SilkTest thus preserving the original formatting:
[ ] MicrosoftExcelExcelbook1.SetActive () [ ] WorkSheet.SetActive () [ ] WorkSheet.Click (1, 60, 31) [ ] WorkSheet.TypeKeys ("") [ ] [ ] lsClipboardContents = Clipboard.GetText() [ ] then parsing code follows...........