You can format any date field or any calculation field with a date result type to show a date in that format if you select the correct date formatting options for the field on the Inspector's data tab.
I collect date in a NoticeDate field. It shows up as Wednesday, February 26, 2014 there because I set that up in properties.
I then have a calculated field that has a formula "The date of the notice is "&NoticeDate
The result in that second calculated field is 2/26/2014 and there is no date option available in the field because it is a text field (the calculated field)
Then your calculation method that you already described may be used.
But do you really need that text to appear in the field? If you pulled that text out by making it layout text or text in a different field that you place next to the field so that the date was only a date, you'd avoid the necessity of such a complex date expression.
Thanks for all of your help:
I think so. I'm still working on getting some HTML formatted information out of FM.
I need the following:
<h1>The Group Title</h1>
<h2>The section title</h2>
The Sale Date: NoticeDate (to show up spelled out)
I then have a button on my interface that copies the contents of that field to clipboard where the user can paste it into the web module we are using.
It's ugly, but better than hand typing and getting all the errors.
Hmmm, I think that maybe you were really asking if there was a function you could use in place of the "hand made" expression that you are using. No such function is "built in" to FileMaker, but if you are using FIleMaker Advanced, you can probably find a custom function for this on the Brian Dunning custom function web site that you can import into your file to make life a little easier.
Seems odd, but thanks for looking.
I've attached a picture that shows the way I'm trying to get my calculated field to render.
This is how I need to copy it out of FM into clipboard.
Any thoughts? Is calculated field the right way to do this?
If you are going to copy this as a single block of text to the clipboard, then a calculation field makes sense to me for this purpose.
If all our part of your data was in a table type format, then a different approach might make more sense but that doesn't fit the example shown here.
Not really, just a different step of the process in my feeble brain. I probably should have come out of the gate with that picture. That's the end goal of that part of the puzzle.
I need it just like that with those linefeeds, etc.
Seems simple yet I'm having trouble finding how to do the line feeds without </p> which I cannot have in the place where I need to copy too.
is an HTML tag for inserting a line feed.
Is there a way to get that crlf without the /br? I need to have it exactly like in the screen shot.
Oh, and yes, I guess I did take this off the date question. :) Thanks for the help.
And what is wrong with using the the /br tag?
I'm not an expert in HTML so there could be other tags that will do what you need that I don't know of.
A number of the "standard answers" that I post into this forum come from a text field where the data is stored with HTML formatting tags--including </br> to put line breaks where needed. The two that I know of are </br> and <p>Your text here </p>. As I understand it, one starts a new line and the other encloses a paragraph.
Nothing wrong with it. What I needed to solve the problem was the (paragraph symbol) found in the calculation box. I did not see it which was why I was so frustrated looking for the simple solution to what was in front of my nose all along.
I'm 90%+ done with my formatting engine. Now I have to figure out how to add this to a relational database of companies to really fix it. :)
Thank you so much for your help, always.