This site requires JavaScript to be enabled
IE BUMPER

Logo

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
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
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).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
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

Comparing Dates in TOSCA

I wanted to know if there is a way to compare dates in TOSCA.

15 0

Michael Müllner

Created: 2016-08-02 19:55:11

Hi Sarem,

You can use the TBox Evaluation Tool module to compare dates with Tosca.

Please note that you will have to enter dates in between hashes (as shown in the below screenshot) so the Evaluation tool will recognize your input values as dates.

 

BR

Michael

2 0

Daniel Yarberry

Created: 2018-02-27 20:54:38

This needs to be a KB immediately! So important. Also time evaluations would work as well.

0 0

Jack Mitchell

Created: 2018-03-20 17:32:18

What order are the fields in ?

E.G. is #02.08.2016# The 8th of february, or the 2nd of August ?

Hozefa Ali

2018-07-26 01:10:26

Totally depends on your formatting, Youc could control using following:

1. Settings->TBox->Dynamic temporal expressions

2. Control it by Test configuration parameters

3. You can generate using below formula

{DATE[base][offset][format]}

Eg: {DATE[02.08.2016][+1y-3M-1d][dd/MM/yyyy]}  will give you "01.05.2017"

Cheers,

Hozefa

0 0

Jelena Jovanovic

Created: 2018-04-30 16:56:25

This just saved my life - Thanks!!! :)

p.s. can't believe you can't find similar information in Manual

0 0

Hozefa Ali

Created: 2018-07-26 03:16:19

Where do we get these tricks, all at once?

As I spent 1-2 Hours googling until I find your artical.

Really helpfull though.

Thanks.

Hozefa

 

0 0

Pavithra S K

Created: 2018-08-01 09:23:54

Date Format Verification:

I want to verify the format of date as 'M/d/yyyy' in excel.

Could anybody help on this?

0 0

Neha Parihar

Created: 2018-08-23 21:11:16

I want to find whether a date is Sunday or not. I have bufferd the date and am trying to use the ADAY to find out if its Sunday or not . First i used the belowin TC Set Buffer to convert to TOSCA date format.

{CALC[TEXT("{B[ProjectStartDate]}","dd.MM.yyyy")]}

Then i use the following to find out what day is it

{ADAY[{DATE[{B[ProjectStartDate]}][][]}]}

But it tells me that 23.08.2018 cannot be interpreted as date. I played with other format too but it just does not like any format.

Although if i just use {ADAY[{DATE[][][]}]} it does give me the day.

Can anybody please help me on this.

Cheers,

Neha

Abhay Hora

2019-04-04 12:16:36

Hi Neha,

Did you find a solution to this. I am facing a similar issue with time format.

Thanks,

Abhay

0 0

Nikita Das

Created: 2019-06-21 12:51:52

I have to compare two dates, one is system Date & the other buffered one.

For e.g., Date 1 = 30-DEC-19 & sys Date= 21-JUN-19 but when I am comparing, the verification is failing. 
#30-DEC-19 # > #21-JUN-19 # is evaluated to 'false'

Can anyone help on this ?

Venkat Gangavarapu

2019-06-25 14:51:31 , Updates: 2, Last Update: 2019-06-26 07:36:39

Hi Nikita, Convert the buffered date to Target format and then compare(see below)

TBox Set Buffer

d1 = 30-Dec-19

d2 = {CALC[Text(""""{B[d1]}"""",""""MM/dd/yyyy"""")]}

TBox Evaluation Tool

Expression  : #{B[d2]}#>#{DATE[][][MM/dd/yyyy]}#

0 0

Shravan Kumar Eetha

Created: 2019-09-09 16:14:05

I want to validate a response date value to the following format( yyyy-mm-dd)

i have a test sheet with the term effective date value and i want to validate to make sure the date i am getting in the response is of the format yyyy-mm-dd , i am unable to do it using the below

 

{XL[termEffectiveDate]}=={DATE[][][yyyy-mm-dd]}

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial