Question
6
Replies
944
Views
Anthem
Posted: April 2, 2019
Last activity: August 26, 2019
Closed
Solved
How to find the shortest datetime in a pagelist
Hi All,
I need to find the shortest date in a pagelist. For example, following is my pagelist
pg(1).Date= April 10, 2019
pg(2).Date= April 25, 2019
pg(3).Date= April 5, 2019
I need to find the index of page with April 5, 2019.
Any help or direction is much appreciated.
Thanks in advance.
You can try to use "CompareDates" function.
It compares two DateTime strings [you need to convert your datetime in string format] and return true if the first date argument is after the second.
Example:
CompareDates("20090109T162504.370 GMT", "20090110T182504.370 GMT") = false