This site requires JavaScript to be enabled
IE BUMPER  Product
Version
Incident
Language
How can we help?

### Solution Suggestions  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.

#### 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.

#### if("" == "e80446621b6c141028da337a1d4bcb22"){ var correct = document.getElementById("fb_correct_KBFB0007051"); correct.className += " correct_trophy"; correct.title = "Correct Answer"; } 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