Votes
Answers
Views
Question
1
1
2200
asked 4 years ago by Alteryx Training
updated 4 years ago by Charles Coleman
Category:
Data Analytics
I'm trying to find the difference between two dates in Alteryx. In Excel, I'd just subract one from the other, but I don't think that works here. Am I supposed to use datetimediff in a Formula tool or something else?
1
1
178
asked 7 years ago by neena
updated 7 years ago by bubblehead712
I'm trying to compare an expected date value to an API datetime field. I need to know how to use the UFT API Custom Expression to grab only the Date portion of the DateTime returned value. Or, is there another way that I can compare the two dates? Currently, when I pass in my expected date only valu...
2
1
177
We have some tests that alter the computer's date and time to test password expirations. This seems to cause our seat license to get corrupted. It seems to go back to the Demo license but says it is expired.
4
1
116
I have Date field that is a WebEdit object Object Property Value is formatted as 2021-01-29 (YYYY-MM_DD). How would I change format to 01/31/2020?
1
1
108
Custom date field not formatting correctly compared to default date in exported excel report in ALM?
Hello, I have created Custom Date field in Defects module. To export all defects, we have written a simple query in AnalysisView and exported all defects. In the exported file, date format is different(yyyy-mm-dd) for custom field where a system field DetectedOnDate is in dd/mm/yyyy format. I...
0
1
104
asked 8 years ago by godawgs
updated 8 years ago by David Hall
I am trying to assign today's date as a value to "BG_CLOSING_DATE". This is working fine in another project. But when I am doing it for another project, I am getting an error. screenshot is attached.![alt text][1] [1]: /storage/temp/450-201603210728421-date.png
0
1
101
asked 6 years ago by coleslaw
updated 6 years ago by jameslcoleman
Hello. I am looking for a way to generate a defect report that displays the latest status changes of Failed, Retest and Reopen. We are wanting the report to include the defect ID, status, old and new status selected, as well as the time of the change. Do you have a query that I can use to create suc...
0
1
74
asked 8 years ago by scruffy
updated 8 years ago by josh-yates
Recently in ALM we changed a field type from String to type Date, now we are getting the error on highlighting some entities: The string was not recognized as a valid Date Time. There is an unknown word starting at index 0
0
2
60
I've got a database checkpoint in my UFT script and it is checking some dates. When I run it on my main UFT machine, it works great. When I run it in different lab configurations, the dates are not matching and I haven't changed anything. I'm getting stuck trying to troubleshoot this.