Formatting a number

Wendy wizardcompserv at gmail.com
Mon Sep 30 13:17:21 EDT 2019


Thanks Doug

But jst( dtd(datefield)+0,'2P0') brought it out as 50 not 05 :-(

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Doug Easterbrook
Sent: 30 September 2019 17:34
To: OmnisDev List - English
Subject: Re: Formatting a number

the following might do it

dat(datefield,’D’)        day of month or one of the other date codes.
dtm(datefield).            day number in month
jst(dtm(datefield),’2P0’).   format with leading zero





Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On September 30, 2019, at 9:14 AM, Wendy <wizardcompserv at gmail.com> wrote:
> 
> Hi 
> 
> I am sure this is something extremely simple but brain has gone numb :-(
> 
> I want to print the date as 01-> 09 and then 10 onwards and the same with the month.
> 
> Is there a short way to do this?
> 
> Many thanks
> Wendy Osbaldestin
> Wizard Computer Services
> Tel:  01260271647
> Mobile: 07740541021
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 




More information about the omnisdev-en mailing list