DateValue function is supposed to return a seriel number by substracting the dat

Navajith K over 10 years ago

DateValue function is supposed to return a seriel number by substracting the date from 01/01/1900 (as per excel), however it returns date in appian. Substracting the date with 01/01/1900 is not giving me the exact value which the datevalue function in excel returns (There is a difference of 2 days). is there any way that I can get the exact result of datevalue function in excel in appian? ...

Discussion posts and replies are publicly visible

0 Patty Isecke
Appian Employee
over 10 years ago

Try =tointeger(userdate(1900,1,1))
You can also check out these other functions:
userdatevalue()
userdatetime()
forum.appian.com/.../Scripting_Functions

More information on serializing values can be found here forum.appian.com/.../Normalizing_Expression_Data
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel