Calculation with date as text

[FMRusty]

Hi,

 

I haven't use Filemaker since Version 7 so very, very rusty at present.  I'd like help with a calculation please.

 

I have a date field that comes out as 2/3/2013  or 16/3/2013.

 

I would like a result that gives me 02032013 or 16032013 with the calculation result as text that I can concantenate with other field text to use as a primary key identifier.

 

Thanks.

[Raybaudi]

Right ( "00" & Day ( Date ) ; 2 ) & Right ( "00" & Month ( Date ) ; 2 ) & Year ( Date )

[FMRusty]

Thank you, it worked perfectly.  Now to get my head around the logic

[LaRetta]

Hi FMRusty,

I would suggest not using meaningful data as 'primary key identifier' because if a mistake is made and you change the date you will break your relationships. Primary keys should always be meaningless. :-)

You also risk breaking your relationships if you change your date format at the OS level. Just something to seriously consider.

[Aussie John]

Thank you, it worked perfectly. Now to get my head around the logic