Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: FileMaker 11 Date to Text
Date: Sat, 01 Feb 2014 09:38:48 +1300
Organization: Aioe.org NNTP Server
Lines: 38
Message-ID: <010220140938489910%HelpfulHarry@BusyWorking.com>
References: <8cre16F53dU1@mid.individual.net> <2-udnWwFsN-_fnbPnZ2dnUVZ_t6dnZ2d@giganews.com> <1lgcwcv.tsckxlaoyfqyN%clkaufmann@gmx.ch>
NNTP-Posting-Host: 2EJqCjbFv2vo+YxNsCIxkw.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.5.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com comp.databases.filemaker:1703

In article <1lgcwcv.tsckxlaoyfqyN%clkaufmann@gmx.ch>, Christoph
Kaufmann <clkaufmann@gmx.ch> wrote:

> jmmLAZ <jmartin@learninga-z.com> wrote:
> 
> > How do I get it to really convert to a string of numbers (021513) in order
> > to put it into the concatenated field
> 
> Assuming you have a date field or calc field with date result to start
> from, the results of the date functions
> 
> day ( date )
> month ( date )  
> year ( date )
> 
> will be 15, 2 and 2013.
> 
> You might want to use something like
> 
> right ( "00" & day ( month ) ; 2 )
> 
> in order to see 02 rather than just 2 for the Feb.

You'll need that for a two-digit Day as well (although one 0 is enough
in both cases). Which gives you a calculation of:

     Right("0" & Month(DateField); 2) & Right("0" & Day(DateField); 2)
        & Year(DateField)

BUT, if you are wanting them to sort in calendar order correctly,
you're better to use a backwards version of the British dating system,
Year Month Day, which give a calculation of:

     Year(DateField) & Right("0" & Month(DateField); 2) 
        & Right("0" & Day(DateField); 2)


Helpful Harry   :o)