OCONV for timedate() (OpenInsight Specific)
At 24 JAN 2001 12:52:40PM Steve Carlson wrote:
I want the format for a date/ time as
02/19/1957 06:00PM
I tried
Display=OConv(timedate(),'DT/^3H')
but this results in
12/31/1967 12:00AM every time, not the actual date/time
Any suggestions??
Thanks
Steve C.
At 24 JAN 2001 01:12PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
TimeDate() is ALREADY in external format. To quote the online help for ICONV "DT" - …"string that evaluates to a date, some delimiter and a time".
World Leaders in all things RevSoft
At 24 JAN 2001 01:20PM Oystein Reigem wrote:
Steve,
Try
oconv( Date():'.':Time(), 'DT/^3H' )
- Oystein -
At 24 JAN 2001 02:04PM Steve Carlson wrote:
Oystein, that's the format… but my computer clock
says 01:04 PM
while the OCONV returns 11:17 AM.
Any more suggestions?
TIA
Steve C.
At 24 JAN 2001 03:06PM Oystein Reigem wrote:
Steve,
Whoops!
Try
oconv( Date() + Time()/(24*3600), 'DT/^3H' )
- Oystein -
At 24 JAN 2001 03:10PM Steve Carlson wrote:
Oystein
Perfect…. Thanks Again for your help
.
.
Steve Carlson
At 24 JAN 2001 03:26PM Oystein Reigem wrote:
…or
oconv( date(), 'D/' ) : ' ' : oconv( time(), 'MTH' )
My mistake was I suddenly thought the internal time 1234.567 meant 567 seconds into the 1234th day, while it actually means .567 of a day into the the 1234th day. It's not often I work with date and time data, so my knowledge is a bit rusty.
I've spent the last few minutes searching through my apps to see if I've made that mistake before. I'm relieved to find I haven't.
- Oystein -