cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Date format error using time between

Vinay_47
Explorer
0 Likes
283

I need help for the below one.
I need to calculate hours between one date object which is already defined and current date

When I am trying to use this formulae
Vassign time and current date are formatted in this format = FormatDate([Assign Time]:"MM-dd-yyyy
hh:mm:ss a")

=(TimeBetween([V Assign Time];[Current Date];SecondPeriod)/(60*60))

I am getting below error
The expression or sub-expression at position 14 in the 'TimeBetween' function uses an invalid data type.

Accepted Solutions (0)

Answers (1)

Answers (1)

ayman_salem
Active Contributor
0 Likes

what type is [Assign Time]?
If it is a String, you must first convert it to the date type using ToDate(   ).