Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

date function in CDS View

former_member694066
Explorer

‎2020 Nov 30 11:54 AM

0 Likes
1,047

In dats_add_days and dats_add_month, the 3rd arguement , 'NULL', 'FAIL', 'INITIAL, 'UNCHANGED' what does this inidicate?

2 REPLIES 2
Read only

maheshpalavalli
Active Contributor

‎2020 Nov 30 12:54 PM

0 Likes
874

I recenlty answered this question, you can check it below:

https://answers.sap.com/questions/13194646/cds-view-date-function.html?childToView=13192952#answer-1...

Read only

former_member695272
Explorer

‎2020 Dec 03 2:14 PM

0 Likes
874

Hi,

FAIL, NULL, INITIAL, and UNCHNGED indicates,

  • "FAIL" (an error raises an exception)
  • "NULL" (an error returns the null value)
  • "INITIAL" (an error returns the initial value)
  • "UNCHANGED" (an error returns the unmodified value of date)

Regards,

Tanuja.