Explain DateAdd function in QTP with example.

Dateadd function is used to find the future date or old date in QTP.

For example -
Let say you are testing a trading application where you need to calculate the settlement date for a given trade with trade date as say today.

Now the formula for finding the settlement date is -

settlement date = trade date + 3 business days

In such scenarios you will have to add 3 business days to given trade date.

You can make use of dateadd function in QTP.

print dateadd("d",3,now) 

Above statement will add 3 days to current date and return the date.
You can also find any previous date using above syntax.

print dateadd("d",-1,now) 
This will calculate yesterday's date

print dateadd("d",1,now) 
This will calculate tomorrow's date

Syntax of DateAdd function in QTP.

Dateadd(interval_Type, Interval_Units, date)

Interval Type can be of below types.

yyyy -  Year
m  - Month
d  - Day
h  - Hour
n  - Minute
s  - Second

Please find below more questions and answers on date and time in QTP.

1. How to extract date part from timestamp in QTP?
2. How to find the name of month of given date in QTP?
3. How to extract time part from given date in QTP?
4. How to extract the second part from given time stamp in QTP?
5. Explain dateadd function in qtp with Example.
6. How to find future date in qtp?
7. How to get the system date in qtp?
8. How to verify the date format in qtp?
9. How to find the yesterday's date in qtp
10. How to find the date difference in qtp
11. How to get the current system date in qtp?
12. How to get the current year in qtp?
13. How to find the name of week day for given date in QTP?
14. Explain now function in qtp.
15. Explain the datediff function in qtp.

Please give your inputs, suggestions, feedback to Us about above QTP topic. We value your thoughts.