This works exactly with what I need. Now I just have to figure out to utilize the "hand picking the red marble" to get results back between the two values.
I want to convert date/time to value where I can subtract one and multiply it by 1440 and result in an 8 digit timestamp.
For example: 3/8/2006 12:00:00 AM = 55847520
I am trying to do the following:
(CDate(DateTimeValue({?DateFrom})) - 1) * 1440;
But I am getting a "this should be a number" and (CDate(DateTimeValue({?DateFrom})) - 1) highlighted
I have done this before in VB Script by typing:
var = CDate(Date) * 1440
var = var - 1440
Any suggestions or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.