OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » date

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

date [message #524312]

Thu, 22 September 2011 22:33

cyrsprite
Messages: 26
Registered: March 2011
Location: Manila, Philippines

Junior Member

the problem is the credit card expiry date (mm/yy) should be greater than or equal to the sysdate (mm/dd/yyyy)

please help me for the solution thanks

Report message to a moderator

Re: date [message #524329 is a reply to message #524312]

Fri, 23 September 2011 00:53

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

Senior Member
Account Moderator

Open item's Property Palette and set its "Lowest Allowed Value" to

$$date$$

Report message to a moderator

Re: date [message #524640 is a reply to message #524329]

Sun, 25 September 2011 21:58

cyrsprite
Messages: 26
Registered: March 2011
Location: Manila, Philippines

Junior Member

i already used it but its not working.. i have receiving date with format 'mm/dd/yyyy' and Credit card expiry date with format 'mm/yy'. I need to check if the expiry date is less than receiving date..Expiry date should be Equal or greater than to Receiving date.

so i write the :ccard_expirydt < :txt_receivedt then message..

please help

Report message to a moderator

Re: date [message #524646 is a reply to message #524640]

Mon, 26 September 2011 00:10

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

Senior Member
Account Moderator

$$date$$ works fine for me. What does "it is not working" mean?

so i write the :ccard_expirydt < :txt_receivedt then message..

Could you post exactly what and where you wrote it?

If it makes any difference to you, 'MM/YY' format mask, applied to a date value, evaluates to the first day of the specified month/year:

SQL> select to_date('09/11', 'mm/yy') mmyy from dual;

MMYY
-------------------
01.09.2011 00:00:00

SQL>

Report message to a moderator

Re: date [message #524656 is a reply to message #524646]

Mon, 26 September 2011 01:10

cyrsprite
Messages: 26
Registered: March 2011
Location: Manila, Philippines

Junior Member

actually its working but in my example i received it , 09-26-2011 and the card expiry date is 09/11 and my code is

elsif :ccard_expiry_date < :txt_received_dt then
set_alert_property ('note_alert', title, 'Warning');
set_alert_property ('note_alert', alert_message_text, 'The Card expiry date must be greater than or equal to the Receiving date...');
al_button := show_alert ('note_alert');

Report message to a moderator

Re: date [message #524658 is a reply to message #524656]

Mon, 26 September 2011 01:17

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

Senior Member
Account Moderator

This seems to be an incomplete code. What program unit does it belong to? Do you see the alert message?

What are :CCARD_EXPIRY_DATE and :TXT_RECEIVED_DT datatypes? Do you, perhaps, have to convert them from one datatype to another (such as from CHAR to DATE)?

Report message to a moderator

Re: date [message #524690 is a reply to message #524658]

Mon, 26 September 2011 03:49

cyrsprite
Messages: 26
Registered: March 2011
Location: Manila, Philippines

Junior Member

they are both in date data type

Report message to a moderator

Re: date [message #524691 is a reply to message #524690]

Mon, 26 September 2011 03:49

cyrsprite
Messages: 26
Registered: March 2011
Location: Manila, Philippines

Junior Member

i try to put to_date but theres an error

Report message to a moderator

Re: date [message #524695 is a reply to message #524691]

Mon, 26 September 2011 03:55

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

Realize that we cannot see what you are doing and where... you'll need to be descriptive to make sure we can help you. You tried to put to_date what, where, how and why ?

Wink

Report message to a moderator

Previous Topic:	"Integration error: SSL failure running another product" with HP Deskjet D2680.
Next Topic:	new form for Oracle apps, turning fields in other forms black

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 13:06:58 CDT 2024