Library/Technical Support/Janova 101

How to verify the current date, previous dates and future dates

Jackson Ridenour
posted this on November 10, 2010 11:29

Synopsis:

This guide explains how to verify dates within an application.

Applicable to:

Verify the current date, previous dates or future dates. 

Prerequisite:

None.

How to: 

  1. Below are the five date verification methods followed by an example of each:
       
    =TODAY() places today’s date in the field
    =YESTERDAY() places yesterday’s date in the field
    =TOMORROW()                places tomorrow’s date in the field
    =DAYS_AGO(X places the value of X number of days ago in the field
    =DAYS_FROM_NOW(X)        places the value of X number of days from now in the field

    NOTE:  The date syntax must be in ALL CAPS in order for the date function to work.
     
  2. Using =TODAY()

    Today_Edit.jpg

    After saving the step
    Current_Date.jpg
     
  3. Using =YESTERDAY()

    Yesterdays_Date_EDIT.jpg

    After saving the step
    Yesterdays_Date.jpg
     
  4. Using =TOMORROW()

    Tomorrow_EDIT.jpg

    After saving the step
    Tomorrow.jpg
     
  5. Using =DAYS_AGO(5)

    Days_Ago_EDIT.jpg

    After saving the step
    Days_Ago.jpg
     
  6. Using =DAYS_FROM_NOW(365)

    Days_From_Now_EDIT.jpg

    After saving the step
    Days_From_Now.jpg
     

 
Topic is closed for comments