Studio 8 Jsforms
David Barnett
David at FairLibertysCall.com
Tue Dec 6 09:32:32 EST 2016
Early in this thread, someone mentioned using: jst(fieldcolumn, 'm D Y H:N’)
Traditionally, the jst() function requires a ‘D:’ at the start of the formatting string (the 2nd param) to indicate that the formatting is for dates. So I would actually expect to see:
jst(fieldcolumn, ‘D:m D Y H:N')
Did that change in Studio 8, or in the JsForms?
David
David Barnett David at FairLibertysCall.com
C: 516-398-8668 www.FairLibertysCall.com
> On Dec 6, 2016, at 9:19 AM, Mayada Al-Kishtini <malkishtini at gmail.com> wrote:
>
> 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
>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en
mailing list