Hi Everyone, I have a text box that is bound to a table. There can either be a date or NA or TBD in this textbox. I have achieved this by using a validation rule:
IsDate([textbox])=True Or "NA" Or "TBD"
However they are requesting that the date format be in m/dd/yy format. I tried entering that under the format field of the table, and I also tried using an input mask, but neither work, I think it's because there can be other text in this textbox, but I'm not really sure what's going on. Is there a better way to get this value formatted only if it's a date that was entered?
IsDate([textbox])=True Or "NA" Or "TBD"
However they are requesting that the date format be in m/dd/yy format. I tried entering that under the format field of the table, and I also tried using an input mask, but neither work, I think it's because there can be other text in this textbox, but I'm not really sure what's going on. Is there a better way to get this value formatted only if it's a date that was entered?