This site requires JavaScript to be enabled
IE BUMPER

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Product
Results per page
Tosca Version
Categories
Version
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.

13 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

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial