Formatting a date in a text field

[ashill]

I have a date formatted as 18-MAR-2010 in a date field, I also have a text field with text in it. I created a calculation which combines these two fields into a third field. My problem is that I lose my date formatting once I get to the third combo text field. Is there anyway to hold on to that format or reformat the date portion once it is in the text field?

This is the calculation I have for the text field - (Transmittal Date & " Group " & Transmittal Group)

Thanks

[TheTominator]

The formatting you describe is a feature of the presentation on the layout and not something stored in the date field itself.

To make the date appear in that format as a string of text in a calculation you will need to do that formatting yourself. Or rather write a formula to teach FileMaker to do it.

You could do it like this:

Right("0" & Day(Transmittal Date); 2) & "-" &

Choose(Month(Transmittal Date); "";

"JAN"; "FEB"; "MAR"; "APR"; "MAY"; "JUN";

"JUL"; "AUG"; "SEP"; "OCT"; "NOV"; "DEC") & "-" &

Year(Transmittal Date)

Edited March 19, 2010 by Guest

[ashill]

That is beautiful! Thank you for your help