Results 1 to 7 of 7

Thread: Date Field

  1. #1
    Join Date
    Jul 2014
    Posts
    20
    Provided Answers: 1

    Unanswered: Date Field

    Is it possible to make a date increase when you press the + key and decrease when you press the - key.

    Will it require writing a script to accomplish the above?

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Not with a single key press.
    You would have to press Ctrl + or Ctrl -

    Hot keys require a Ctrl press in conjunction with the key you want to assign a function to. You can however put two buttons on your form beside the date field that would do what you need.

    Regards
    James

  3. #3
    Join Date
    Jul 2014
    Posts
    20
    Provided Answers: 1
    Thank you for your reply. I will experiment with that option.

  4. #4
    Join Date
    Jul 2014
    Posts
    20
    Provided Answers: 1
    Yes that worked:

    Using the button with set field value (math) and the formulas below.

    dateAdd([DateFilled],1,|Day|)

    dateAdd([DateFilled],-1,|Day|)


    Thank you again for the information.

  5. #5
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Or you can use a more simple maths action....
    [DateFilled] = [DateFilled]-1

    [DateFilled] = [DateFilled]+1

    There's no need to specify the dateAdd formatting at all when dealing with days.

    Regards
    James

  6. #6
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    for entering time data i had used 3 combo boxes with predefined text in the combos

    hours in a combo, from 0 to 12 and minutes from 0 to 60 that could be useful also

    fer

  7. #7
    Join Date
    Jul 2014
    Posts
    20
    Provided Answers: 1
    Thank for the information on not needing to use dateAdd function.

    Thank you for the information about using buttons and time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •