Studio 8 Jsforms

Mayada Al-Kishtini malkishtini at
Tue Dec 6 09:13:13 EST 2016

I use this trick: (mid(datetime,1,25))  in the client method $formatcell:

Calculate columnDesc as mid(iResultList.[pRowNo].datetimeadded,1,25)     

The date/time is stored in following format in the db:
"2016-12-01 07:44:00"

And with using the above code, the date/time is displayed in the jsform as
Dec  1 2016  7:44 am

I tried using jst() and I got the error as well.


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at] On Behalf Of Alain Pelloux
Sent: Tuesday, December 06, 2016 6:50 AM
To: OmnisDev List - English
Subject: Re: Studio 8 Jsforms

Same question ; with format('m D Y H:N',iDate)

*            Alain PELLOUX*

      Développeur IT & Logiciel

       IT & Software Developer
         +33 (0)4 77 36 84 30

apelloux.snf+omnisdev at <apelloux.snf%2Bomnisdev%2Bfr at>

On Mon, Nov 21, 2016 at 5:24 AM, <brian at> wrote:

> Trying to format a string inside a datagrid.  I have the 
> kJSDataGridModeCustomFormat set and on the methods for the datagrid I 
> have an $formatcell method where I'm trying to format a string using the jst().
> But, that is not working.   Using jst(fieldcolumn, 'm D Y H:N') and not
> working with a message that jst() doesn't recognize D and Y.   Need to have
> a date and time column that won't bring up the JS calendar when you 
> enter it and allows you to input the time.
> Thanks,
> Brian
> _____________________________________________________________
> Manage your list subscriptions at
Manage your list subscriptions at

More information about the omnisdev-en mailing list