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.