Hi,
I have an issue where I'm validating date information in our web flow form data in our SQL tables, the date in the web flow is a standard format eg. 13/12/2018 however the SQL data driven information format includes the time so 13/12/18 14:46:16 so causes the test to fail. Normally id just do attribute contains but its the wrong way around so still fails, how do I get around this? would i be able to trim the value using regex? If so how do I do this with data driven information?
Thanks
Trimming sql data to validate against
- RobinHood42
- Posts: 324
- Joined: Fri Jan 09, 2015 3:24 pm
Re: Trimming sql data to validate against
Hi,
I assume that you're retrieving your data from an Ranorex SQL data connector/source, which is bound to a variable. You'll now have to create a CodeModule to retrieve the actual date information from your web form. This value needs to be compared to a parsed/normalized form of the value of the variable.
I hope this helps.
Cheers,
Robin
I assume that you're retrieving your data from an Ranorex SQL data connector/source, which is bound to a variable. You'll now have to create a CodeModule to retrieve the actual date information from your web form. This value needs to be compared to a parsed/normalized form of the value of the variable.
I hope this helps.
Cheers,
Robin