date Time field and display the day before

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I would like to simply have an end date and have my field show the date before

I tried this date formula

ToDate([VOD 1 End]) - Days(1)

But I get this error

The types of the arguments or the number of arguments supplied do not meet the requirements of the function ToDate.

The function ToDate can be used with the following arguments:

  • ToDate (Text x).
  • ToDate (Text x, Text f).
  • ToDate (Date/Time x).




Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 742 Points 500 badge 2x thumb
What is the Field Type of [VOD 1 End]?
Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb
Date
Photo of dwhawe

dwhawe, Champion

  • 742 Points 500 badge 2x thumb
Since it is already a Date, you don't need to change it to a date
Photo of dwhawe

dwhawe, Champion

  • 742 Points 500 badge 2x thumb
Get rid of the ToDate and use:  [VOD 2 End] - Days(1)
Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb
Great, that did it!