How to use different date functions
Using different excel date functions in Tosca
How to use Different date 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
- To find the day of the week of a given date
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.
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
Expected results: This expression gives you the result as false as the first given date is smaller than the second one.