Studio 8 Jsforms

[Mayada Al-Kishtini]

One more thing, my date/time column is defined as #FDT in the schema class.
I didn't do any specific calculation to the format of #FDT in my code, probably it is done somewhere else in the app.

HTH,
Mayada

-----Original Message-----
From: Mayada Al-Kishtini [mailto:malkishtini at gmail.com] 
Sent: Tuesday, December 06, 2016 9:13 AM
To: 'OmnisDev List - English'
Subject: RE: Studio 8 Jsforms

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.

HTH,
Mayada


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] 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 gmail.com <apelloux.snf%2Bomnisdev%2Bfr at gmail.com>

On Mon, Nov 21, 2016 at 5:24 AM, <brian at revolution911.com> 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 http://lists.omnis-dev.com
>
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com