Visokio website     Downloads     Video tutorials     KnowledgeBase  
Functions : Excel Equivalent to TODAY() - Visokio Forums
Functions : Excel Equivalent to TODAY()
  • mttwnxn February 20, 2017 6:34AM
    Hi - is there any equivalent to the TODAY() function in excel?
  •     paola February 20, 2017 6:49AM
    Function syntax is the same (Omniscope / Excel).
    also available - NOW()
    both useful to combine in formulas and insert either in date format or text, in combination with other functions, such as DATETOTEXT:

    "dd/MM/yyyy hh:mm")

    To explore other date functions please click on the "date" filter on this page:
  • mttwnxn February 20, 2017 7:01AM
    Thanks Paola - is it possible to call this directly in a record filter? I hit an error when I try to set this up. Or do I have to set up a formula first?
  •     paola February 20, 2017 7:15AM
    You can create formulas in:
    - DataManager's Field Organiser block (Create new field>use formula)
    - DataExplorer's Table view Tools>Formulas>Add formula field
    - Data>Manage fields >Add new field

    You cannot enter "TODAY" in the [Date] field filter and expect it to return records with today's date.
    Having said that... You could set up a new formula field with :


    Now you can :-)
  • mttwnxn February 20, 2017 7:27AM
    Thanks again for your help Paola - I will test this now.


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership