86399 is the number of seconds in 24 hours minus 1. when you put in the date,it normally will revert to 00:00 on the day, since you wanted 11:59pm, so I added 24 hours to the date and took away 1 second
kind regards
shafqat
ramakanthvarma bhupathiraju <[EMAIL PROTECTED]> wrote:
**Hi Shafqat,Thank you very much.$DATE$ + 86399 is working, can you please explain how u got the No 86399.Thanks,BRK
On 5/2/06, Shafqat Ayaz <[EMAIL PROTECTED]> wrote:** Or you could do $DATE$ + 86399
kind regards
shafqat
Frank Caruso <[EMAIL PROTECTED] > wrote:** How about doing a set fields to do $DATE$ + " 11:59:59 PM"
On 5/2/06, ramakanthvarma bhupathiraju <[EMAIL PROTECTED] > wrote:**Hi list,I have a date time field in a form and on click of button it gets the $timeStamp$. the format will be 05/02/2005 7:47:48 PM.My requirement is when we click on the button the date time field should get updated as 05/02/2005 11:59:59 PM every time.i.e. date should be current date but the time has to always be as 11:59:59 PM. in the date time field.Any thoughts abt this would be greatly appreciated.RegardsBRK__20060125_______________________This posting was submitted with HTML in it___
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-879-6465 __20060125_______________________This posting was submitted with HTML in it___Shafqat Ayaz
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. __20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
Shafqat Ayaz
Blab-away for as little as 1ยข/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice. __20060125_______________________This posting was submitted with HTML in it___
