DATEVALUE() function?

[john w]

I need to convert a Date in InDe to a serialized number like in Excel or Google Sheets. I am looking for something like this "The DATEVALUE function is used in Excel and Google Sheets to convert a date represented as text into a serial number that can be used in date calculations. This serial number represents the number of days that have passed since January 1, 1900."

How do I achieve something like this in Instant Developer. I need to use the date numbers in a Slope calc.

Any help is appreciated.

[d.pierangeli]

Should be sufficient to convert the date into an integer:

int i = toInteger(now())

The result should be the days after 12/30/1899.

[john w]

Thank you that was what I was looking for! I did not see it in the documentation, it might be worth adding if it is not there.