Dear Isomorphics,

When I need to have a column in ListGrid with a numeric calculation, I usually use the "Add Formula Column..." option from the ListGrid context menu. Recently, I found myself needing to perform calculations between dates within those formula fields and discovered that the dateAdd() function can be used. However, when trying to perform arithmetic operations with this function, I noticed that when I add a number, I get a dot as a result, but when I perform other operations such as subtraction, multiplication or division, I get a numeric result.

In the attached images you can see the behaviour described above.

I would like to know which of these two behaviours is expected and if it is correct that the dateAdd() function returns a numeric result. Also, I would be interested to know if it is possible to get a result in the form of a date instead of a number in these calculations.

We are working with version 13.0

When I need to have a column in ListGrid with a numeric calculation, I usually use the "Add Formula Column..." option from the ListGrid context menu. Recently, I found myself needing to perform calculations between dates within those formula fields and discovered that the dateAdd() function can be used. However, when trying to perform arithmetic operations with this function, I noticed that when I add a number, I get a dot as a result, but when I perform other operations such as subtraction, multiplication or division, I get a numeric result.

In the attached images you can see the behaviour described above.

I would like to know which of these two behaviours is expected and if it is correct that the dateAdd() function returns a numeric result. Also, I would be interested to know if it is possible to get a result in the form of a date instead of a number in these calculations.

We are working with version 13.0

## Comment