OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » date

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

date [message #459018]

Thu, 03 June 2010 00:47

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

i have create one standard Calender
from that i pickup month date and year separately like 2/6/1987

now i want to convert it into standard date format

how to convert it and pass to another block....

Report message to a moderator

Re: date [message #459023 is a reply to message #459018]

Thu, 03 June 2010 01:00

lokeshsurana
Messages: 212
Registered: April 2010
Location: India

Senior Member

i write code on when-button-pressed trigger....

begin
:global.v1:=:bl_calendar.date_cal;
:global.v2:=:bl_calendar.cal_month;
:global.v3:=:bl_calendar.cal_year;

if :global.temp=1 then
:global.v4:=(:global.v1||'-'||:global.v2||'-'||:global.v3);
:cust_po.created_date:=to_date(':global.v4','dd/mm/yyyy');

go_block('cust_po');
hide_window('window_calendar');
else
:cust_line.need_by_date:=(:global.v1||'/'||:global.v2||'/'||:global.v3);
go_block('cust_line');
hide_window('window_calendar');
end if;

end;

it did not get convert in standard date format.....and not getting convert into date so forms not able to close..?

Report message to a moderator

Re: date [message #459028 is a reply to message #459023]

Thu, 03 June 2010 01:40

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hello

First of all you need to convert it into date format. And if you pass the date to function To_date(sysdate) it will convert it into NLS_DATE_FORMAT. Is this what you meant?

Thanks
Sinida

Report message to a moderator

Re: date [message #463872 is a reply to message #459028]

Mon, 05 July 2010 00:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

Look at changing the 'format_mask' of the displayed item.

David

Report message to a moderator

Previous Topic:	Voucher no financial year wise
Next Topic:	Unable to display Do you want to save the changes you have made? message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:34 CDT 2024