Skip to Content
0
G B
Jul 07, 2016 at 12:01 PM

Issue with secondsbetween() function in calculated column

215 Views

Hello

I am able to get results when I use the below versions of secondsbetween() -

secondsbetween(date(1992,11,03,12,24,00),date(2016,07,07,16,42,00))

secondsbetween(seconddate('2016-07-01 09:10:15'), seconddate('2016-07-01 09:15:45'))

secondsbetween(longdate('2000-02-03 13:50:26'),longdate('2000-02-03 14:50:26'))

but when I use secondsbetween(date('2000-02-03 13:50:26'),date('2000-02-03 14:50:26')), it is giving me 0 as the result.

Please let me know why this is happening.