0
 Followers
2
 Likes

Two new Date Functions DateDiff(datepart,startdate,enddate) and DateAdd(datepart,number,date)

Builtin & User functions
On our radar

These two functions are common and enable us to do more fine grained date math. As built, the system doesn't allow me to add weeks or calculate the number of weeks between two dates.

Two generic functions to make such calculations will open up outsystems to many more date calculations.

See the following for more info on requirements:

https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-2017


Created on 19 Sep 2018
Comments (2)

Changed the category to Builtin & User functions


Changed the status to
On our radar


Hi PJ M,

Thank you for bring this up in our community. We believe that that is space for improvement in terms of functions related to date manipulation and also Math. 

We will mark this idea as in our radar to evaluate.

Cheers

views
485
Followers
0