OraFAQ Forum: Forms » Validation using A.M P.M (merged)

Home » Developer & Programmer » Forms » Validation using A.M P.M (merged) (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Validation using A.M P.M (merged) [message #486706]

Sun, 19 December 2010 05:51

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Dear All,

I have two date fields in my form one start date and the other is end date.I have changed their properties to datetime and set the initial value $$dbdatetime$$ and format mask to dd/mm/rrrr 24HH:MM , what i want is

1.i want to display the A.M and P.M along with that.
2.If the time and date of end dt is lesser than start error must come.
3.If the user enters the P.M during the day time before noon then it should give error message.

Report message to a moderator

Re: Validation using A.M P.M (merged) [message #486711 is a reply to message #486706]

Sun, 19 December 2010 07:01

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) The form builder help topic does list all the possible date formats, you should read it.
2) That's what when-validate-record triggers are for. This is about the most basic check imaginable.
3) Or check if the date entered is greater than midday and sysdate is less than midday.

Report message to a moderator

Re: Validation using A.M P.M (merged) [message #486734 is a reply to message #486711]

Sun, 19 December 2010 13:31

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As of 1: if format says that you use 24 hours, what good does AM/PM do? 20:15 is 08:15 PM, but what would 20:15 PM be? Obviously, you can't make it 20:15 AM.

Report message to a moderator

Previous Topic:	Can Test Custom Jars with 6i Run Form -> Client/Server?
Next Topic:	Open file JavaBean for Web Deployed Forms 6i and WIN_API_DIALOG.OPEN_FILE crashes IE (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:06:33 CDT 2024