Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add x Days to a Date Field

Received Response
21
Views
1
Comments

Summary

Add x Days to a Date Field

Content

Hello All,

I have a situation where I need to add 'X' no. of Days to a Date field. Do you have any clues or has any one done this before? I have no Clue how to proceed for this.

Thanks

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    If your source is sql then add directly at source level , select sysdate+x from dual , where X will be number of days to add.