When entering dates in Ivo there are a variety of shortcuts you can use.



Basic shortcuts



Shortcut
Description
t
Today's date
t +/- number
Today's date, plus or minus a number of dates.

For example, if today's date is 6-Jul-2019 then "t-3" will give a date of "3-Jul-2019"
t number
Today plus number.

If today's date is 6-Jul-2019 then "t1" will give a date of "7-Jul-2019"
y
Yesterday
tm
Tomorrow



Advanced shortcuts



First Letter

Second Letter

Third Letter

s
Start of
l (L)
Last
w
Week
e
End of
t
This
m
Month


n
Next
q
Quarter




h
Half year




c, y
Calendar year




f
Financial year



Examples


slm
Start of Last Month
elf
End of Last Financial year
snf
Start of Next Financial year



The advanced shortcuts are most useful when entering date ranges for queries and reports.




Image PlaceholderImage Placeholder



The shortcuts can be entered in either lower or upper case.



Using Date Shortcuts in the Browse Data function


You can use these shortcuts in the "Filter Value" column of the "Selected Fields" table.  Simply enclose the shortcut in curly braces, with a leading $ symbol.  For example, the shortcut for "Start of Last Month" is "SLM" and would be used like this - {$SLM} - in the Browse Data tool.  It would look like this -

Image Placeholder

This query would return all file notes created in the last 30 days.