Skip to main content
Known Participant
February 13, 2016
Question

Value based on date

  • February 13, 2016
  • 1 reply
  • 488 views

I want a value returned in Text1 field based on a date in Date1 field. For instance if the date in the Date1 text field is todays date or before than the value in the Text1 field should be "Expired" if the value in the Date1 text field is tomorrow or any time in the future than the value in the Text1 field should be "Expires"

This topic has been closed for replies.

1 reply

try67
Community Expert
February 13, 2016

What's the format of the value in Date1?

senechiaAuthor
Known Participant
February 13, 2016

dd/mm/yy

senechiaAuthor
Known Participant
February 13, 2016

However the date could be 3/1/16