Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1703

Re: FileMaker 11 Date to Text

Show all headers | 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