on ‎2025 Feb 21 4:38 PM
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.
Request clarification before answering.
what type is [Assign Time]?
If it is a String, you must first convert it to the date type using ToDate( ).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.