Date function in Day 5

Results 1 to 2 of 2

Thread: Date function in Day 5

  1. #1
    Join Date
    Dec 1969

    Default Date function in Day 5

    I have used the 3 compo box to collect day, month, year separately, I covert the string through cdate function, suppose user may attempt to give 2/31/2002, 11/31/2002 - wrong date - how to change to march 1, Nov 30 respectively. Please suggest me<BR>Thanks<BR>Mathavan, India

  2. #2
    Join Date
    Dec 1969

    Default RE: Date function in Day 5

    There is no easy way to do this, from what I know. What you would have to do is first determine the number of total days in a given month. See:<BR><BR><BR>Then you could see if users day field for the given month was greater than the # of total days for the month. If it was you could take corrective action.<BR><BR>hth

Posting Permissions

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