BOXI querry Current Date
- skarbnik
- Nov 4, 2015
- 1 min read
Now – 2 hours
=RelativeDate([Date];-0.0833333333333333)
2 hours from 24 hours (1 day) = 0.083333333 of a day.
LastExecutionDate
=FormatDate(LastExecutionDate();"HH:mm")
CurrentDate: This returns the current data value; it is great for calculating time differences.
Daysbetween: This calculates the number of days between two dates (the order date and arrival date).
Todate: This converts a string object into a date type object. This option is great for when we have string objects that we need to sort chronologically or use in other date ...
=RelativeDate(CurrentDate(); -1)
Comments