Subtracting the Date/Time fields
-
Hi - I need to create a formula for finding the date difference.
=if(Create_date - Start_date < 24hrs,"Yes",NULL)
Can anyone help me on getting the formula for this one please. Thanks in advance -
2 Comments
-
http://www.visokio.com/kb/functions-guide#DATEDIFF
IF(DATEDIFF(Create_date, Start_date, "hours") < 24, "Yes", NULL) -
Thanks a lot as usual it works great... :)
This discussion has been closed.
← All Discussions Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.