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.

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

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

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.

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