maclse

Thanks Lee, It worked like a charm. Text1 & "_" & Right("0" & Month(Date1), 2) & "/" & Right("0" & Day(Date1), 2) & "/" & Right(Year(Date1), 2) How did you figure it out? Trial and error? Thanks again.

I tried Dan's? (danjacoby) recomendation for changing the four digit date to two digit (Q2 above), and it worked. Does anyone know how I can make the Month and Day to show 01/01/03 instead of 1/1/03 (add leading zero...without incorporating an If statement) when combining a text and date field in a caculation? Thanks again!

So I've found a weakness, eh? Thanks to both of you for your help! Much obliged! Maclse

I am new to FM (FMP 6, OSX) and I've spent a couple days searching for answers to my questions on this forum. Thanks to all those who have taken the time to answer posts, you've been very helpful! I have a couple questions of my own... Question 1: How do I preserve text formatting (such as superscripts/symbols) in a text calculation field that combines one or more text fields? Question 2: If I have a text calculation field that combines a text field and a date field, how do I format the date part of the calculation to display 01/01/03 instead of 1/1/2003 (For example: ProdID = TextField1 & Month(Date1) & "/" & Day(Date1) & "/" & Year(Date1)? Question 3: I want to create a number field that only displays numbers in scientific notation (ie. 1E+8 instead of 100000000), how would I do this given this is not a number field formatting option? Thanks in advance!