O$5.2 js Dates and Times

[Christine Penner]

We get around that by using schemas or queries that have the date/time 
type set the way we want. If using a schema is not convenient then local 
or instance variables can do the same thing. So its the field the 
date/time goes into that controls what the format is.

Christine Penner
Ingenious Software
250-352-9495
chris at fp2.ca


On 08/05/2012 11:15 AM, Mark Jenkins wrote:
> I am having an issue with is date and time fields in a complex grid.
>
> DB is FrontBase.
>
> I have a ShortDate field and a ShortTime field.
>
> The js grid appears to only permit a single date or time display format.
>
> I am getting bad dates in the Time field and bad times in the Date field.
>
> If I use the kjsFormatNone the fields look like:
> Sun May 06 2012 19:00:00 GMT-0500 (Central Daylight Time)
>
> Holy cow! That's a wide column for a Short Date field!  lol
>
> kjsFormatFullDateTime:
> Sunday May 6 2012 7:00:00 pm -05:00
>
> kjsFormatShortDatTime:
> 05/6/12 7:00 pm
>
> What's really strange is the fact that the date value is completely 
> wrong! It's two days in the past!
>
> Dates and Times will be the end of me of that I am sure.  Don't even 
> get me started on Timezone Offsets and Daylight Savings Time issues!
>
> Mark
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
>