This site requires JavaScript to be enabled


Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

Date Format where month is in words

I'm automating inserting records into an Oracle SQL database, where the date needs to be in the format "17-DEC-2019". 

I have no problem using the usual date formatting for other formats, e.g. {DATE[][][]}, but I don't know how to get a date into the above format.

Help with this would be appreciated.

0 0

Tom Byres

Created: 2019-12-17 16:44:05

If anyone else was wondering, one solution is {DATE[][][dd-{CALC[UPPER("""{AMONTH}""")]}-yyyy]}

0 0

Venkat Gangavarapu

Created: 2019-12-26 13:05:37

Hi Tom, the same 'Upper' method that you used..but just kept it outside of Date for more clarity.




Venkat G.


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial