Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Exclamation Unanswered: Displaying all the dates in a month

    Dear Friends,

    How can i display all the dates in a month.

    Please Help.

    Thanks and have anice day,

    Dew

  2. #2
    Join Date
    Jan 2004
    Location
    Jersey, UK
    Posts
    108
    something like this might work. Maybe an expert on the forum could pick up the ball from here. It loops through a set of numbers and populates a textbox in the format like this:
    31/11
    30/11
    etc.

    numberVar xdate := 0;
    stringVar allDates := '';

    switch(
    month(currentdate) = 1, xdate := 31,
    month(currentdate) = 2, xdate := 28,
    month(currentdate) = 3, xdate := 31,
    month(currentdate) = 4, xdate := 30,
    month(currentdate) = 5, xdate := 31,
    month(currentdate) = 6, xdate := 30,
    month(currentdate) = 7, xdate := 31,
    month(currentdate) = 8, xdate := 31,
    month(currentdate) = 9, xdate := 30,
    month(currentdate) = 10, xdate := 31,
    month(currentdate) = 11, xdate := 31,
    month(currentdate) = 12, xdate := 31);

    while xdate > 0
    do
    alldates := alldates & cstr(month(currentdate));
    xdate := xdate -1;


    alldates

  3. #3
    Join Date
    Oct 2003
    Posts
    357

    Thumbs up

    Hi dew, try this also. Create a new Formula field and write this code
    Code:
    DateVar x := date({datefiled});
    monthname(month(x))
    Madhivanan

Posting Permissions

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