Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How can i make a validation rule for a certain day of a date?

Discussion in 'Information Technology' started by tanhus, Jul 28, 2006.

  1. tanhus

    tanhus
    Expand Collapse
    Guest

    I am trying to make a validation rule so that when i enter in a date in a
    table it will only accept dates that occur on a Friday. Can someone help me.
    Thanks
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Weekday([YourFieldName])=6

    "tanhus" wrote:

    > I am trying to make a validation rule so that when i enter in a date in a
    > table it will only accept dates that occur on a Friday. Can someone help me.
    > Thanks
     
  4. jleckrone@hotmail.com

    jleckrone@hotmail.com
    Expand Collapse
    Guest

    There's a function called Weekday. It would look like this:
    Weekday(DateValue). It will return an integer value for the day of the
    week, Sunday = 1, Monday = 2, etc. If you want the actual name of the
    day ie "Sunday", "Monday", etc do this: Format(Weekday(DateValue),
    "dddd"). Hope that helps.
     

Share This Page