Results 1 to 5 of 5

Thread: Date Field

  1. #1
    Join Date
    Jun 2004
    Posts
    42

    Unanswered: Date Field

    Hi.......
    which code can i write to check the expiry date field is larger than the issue date, and in which trigger shall write this code.

    thanks,

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    In what event you want to check the expiry date > issue date!!

    It can be check in proceudre + trigger.

    trunc(expiry date )>trunc(issue date)




    ### No need ro check web before posting your question


    Thanks,
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Jun 2004
    Posts
    42
    Thanks for the reply ,i need to check it in the insert mode if i put a date in the expiry field that is before the issue date it shouldn't allow me.and i have to reinsert the date again.
    shall i write it in when validate item trigger for the expiry date.

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Yes you can write a trigger. In trigger you can check the condition for date.

    expDate >IssDate raise the oracle exception
    end if
    Pagnint
    (No need to search web before posting new question)

  5. #5
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Yes you can write a trigger. In trigger you can check the condition for date.

    expDate >IssDate raise the oracle exception
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

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