Skip to main content
Question

Date Field Help

  • November 20, 2023
  • 0 replies
  • 35 views
Forum|alt.badge.img+8

Hello, 

I have a date field for users to input a date of birth, but I'm wanting to know if there is a way to make the field not have the date be a future date or entered in a incorrect format? For example, 12/20/2023 or 05/32/0210?

Thanks, 

LB



------------------------------
LB
------------------------------
    This topic has been closed for replies.

    AdamKrzyzanek
    Forum|alt.badge.img+10
    • AdamKrzyzanek
    • Registered
    • November 20, 2023

    Am I understanding it correctly, that you want to have validation if date is in the future or not?

    You can use 3 separate technics:

    1) Form Rules - if you capture input via form you can use form rules that if Date field is Greater than today show error + Block Saving

    2) Formula field - You can create formula field which will validate if entered date is in the past.

    3) You can use "Table --> Advance Settings --> Custom data rules" to block it in Form and in Grid Edit.



    ------------------------------
    Adam Krzyzanek
    ------------------------------
    Terms & ConditionsAccessibility statement