Difference Between DateAdd and DatesinPeriod Function

[Anonymous]

Hi experts,

I tried engine search, but couldnt able to undertand what is the difference between DateAdd and DatesinPeriod Function.

In what scenorios both are used. Can any one help me to explian, Please!

Many Thanks 

[amitchandak · Accepted solution]

@Anonymous , DateAdd add a day, month, qtr, week, or year to date and give a new date.

DatesinPeriod return the range of dates based on the given date and period