Groups > comp.databases.filemaker > #1703

Re: FileMaker 11 Date to Text

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> (permalink)
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

Show key headers only | View raw

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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

RE: FileMaker 11 Date to Text jmmLAZ <jmartin@learninga-z.com> - 2014-01-31 11:53 -0600
  Re: FileMaker 11 Date to Text clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-01-31 21:20 +0100
    Re: FileMaker 11 Date to Text Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-02-01 09:38 +1300

csiph-web