Home » Developer & Programmer » Forms » Forms Sysdate with Time Tag
Forms Sysdate with Time Tag [message #85977] Wed, 18 August 2004 19:58 Go to next message
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
Member
Hi All

I have one very small problem. I am using forms 6i.

Now I wish to pass date through forms into one field which I am not showing on the screen. I am using sysdate for the same.

However the time factor does not pass iwth same I want the current server time tag also attached with the date part as this is an Audit Trail field.

Also in some forms it works in some cases it does not.

Is there any specific reason. What is it so that I can do the needfull. Thanks in advance to all.

Regards

Atul P

 

 

 

 

 

Report message to a moderator

Re: Forms Sysdate with Time Tag [message #85980 is a reply to message #85977] Wed, 18 August 2004 20:17 Go to previous messageGo to next message
AB
Messages: 41
Registered: July 2002
Member
Hi,
Is your hidden field datatype is 'DATE'? Change it to 'DATETIME'. It should work.

Hope it helps you

Regards
AB

Report message to a moderator

Re: Forms Sysdate with Time Tag [message #85982 is a reply to message #85980] Wed, 18 August 2004 22:10 Go to previous messageGo to next message
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
Member
Thks Buddy........

Report message to a moderator

Re: Forms Sysdate with Time Tag [message #85989 is a reply to message #85982] Thu, 19 August 2004 05:22 Go to previous message
domingo
Messages: 54
Registered: June 2004
Member
Change the data type to date time and check if the format property is okay.
thnkx
shub

Report message to a moderator

Previous Topic: what is the relation LOV Query with the master key?
Next Topic: convert rdf to rep
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 19:31:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.