This site requires JavaScript to be enabled
IE BUMPER

Product
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

How to use different date functions

Using different excel date functions in Tosca


Situation

How to use Different date functions

Functions

  • Weekday: To know if a date is which day of the week.
  • Datedif: To know the difference between two dates (Number of days)
  • If: To know if a date is greater than other


 

Solution

WEEKDAY :

  • To find the day of the week of a given date

            {CALC[WEEKDAY(DATE(2018,3,18))]} 

            Expected result: For the above-given date, the result will be 1 (Sunday)

            Sunday= 1, Monday=2, Tuesday=3, Wednesday=4, Thursday=5, Friday=6 Saturday=7

  • DATEDIF :

           To find the difference between two given dates.

            {CALC[DATEDIF(DATE(2018,2,10),DATE(2018,2,21), """d""")]}

            Expected result: Above expression will give you the results as 11 (Difference between the given dates is 11 days.)

  • IF :

           Given two dates we find which date is bigger amongst the two dates 

          {CALC[IF(DATE(2018,1,3)>DATE(2018,3,24),"""True""","""False""")]}

          Expected results: This expression gives you the result as false as the first given date is smaller than the second one.

 

 

0 0

Shubhangi Sonwane

Created: 2020-05-06 09:42:34

Hi,

When I'm using same DATEDIF functions by changing the dates its showing me -ve values.

{CALC[DATEDIF(DATE(2020,5,6),DATE(2020,5,1), """d""")]}

Result: -2146826252

Please help me to understand the issue.

0 0

Swapnil K

Created: 2021-04-29 10:25:13 , Updates: 1, Last Update: 2021-04-29 10:26:20

Hi you need to reverse the dates: {CALC[DATEDIF(DATE(2020,5,1),DATE(2020,5,6), """d""")]}