Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Difference Between DateAdd and DatesinPeriod Function

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 explia...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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