Subject Re: leading zero
From Mervyn Bick <invalid@invalid.invalid>
Date Thu, 23 Apr 2015 22:43:49 +0200
Newsgroups dbase.getting-started

On Thu, 23 Apr 2015 20:09:00 +0200, eric wu <ericwuu@hotmail.com> wrote:

> what is the best easy way to covert a number with leading zero ?
>
> f.e. setup length to 5 , convert 123 to '00123'

Ken has dealt with this one.

>
> the best easy to convert date {04/22/2015} to '2015-04-22'


  transform(dtos(query1.rowset.fields["whatever"].value),"@R 9999-99-99")

Mervyn.