Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2013
    Posts
    37

    Answered: Returned date from a specified week

    Hi,

    I would like to get date of each day from a specified week. Month: Week 1 - Week 2 - Week 3 - Week 4.

    If i select ''week 1'' it'll return the day1 as ex.: April 1, 2015 day 2 : April 2, 2015 etc...
    All week is driving from a ''Year'' roll-down selector and ''month'' roll-down selector.

    The simple ideas is to make a custom Calendar week.

    Thanks for help

    Martin

  2. Best Answer
    Posted by Tubbritt

    "Hello.

    I can see what the problem is. The code works, but the problem is your PC language settings are not set to English.

    If you modify the "Days" drop down list and replace the English words listed there with the days of the week written in your language, then it will work.

    Regards
    James"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    You will need a Week1 start date. I have a tConfig table to save special values.
    Now, does the week always start on a Sunday, Monday, or does it start exactly on the date saved in the config file?

    The rest would be math.

  4. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    You need to use "Date Serials" and a Loop.
    See attached for a working example.

    Regards
    James
    Attached Files Attached Files

  5. #4
    Join Date
    Sep 2013
    Posts
    37
    When i try to select something it get me error: Too many Go to jump. Continue executing the Script?
    Thanks

  6. #5
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Don't know what to say, it's working fine for me.

    I just downloaded and retested the file.

    Regards
    James

  7. #6
    Join Date
    Sep 2013
    Posts
    37
    I tried with 10.31 and also with 10.5 and the same things happen.
    Click image for larger version. 

Name:	bdb.jpg 
Views:	14 
Size:	245.6 KB 
ID:	16301

  8. #7
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Hello.

    I can see what the problem is. The code works, but the problem is your PC language settings are not set to English.

    If you modify the "Days" drop down list and replace the English words listed there with the days of the week written in your language, then it will work.

    Regards
    James

  9. #8
    Join Date
    Sep 2013
    Posts
    37
    Thanks alot James.

    I plan to make another more reliable calendar view. This will be a great start.

    Thanks Again!

    Martin

Posting Permissions

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