Jump to content
bcooney

Default Date Format

Recommended Posts

So, here's something I've lived with forever and I'm finally asking for help!

Can you set a default date format? I'd like all my date fields to display as mm/dd/yy. However, I find that I must use the Inspector's Date Format to do so and I cannot see how to make that the default format.

Anyone?

Share this post


Link to post
Share on other sites

What date format is it defaulting to?

Mine seem to default to my local settings - as I'm in Australia, I get dd/mm/yyyy when I just create a date field. For some fields where I use a slightly different format, I copy a field with the format I want and it's maintained.

 

Share this post


Link to post
Share on other sites

Check the Data Entry Options (File->File Options...->Text)

Share this post


Link to post
Share on other sites

I'm not talking about system formats in the File Options. I want to drag out a date field and have its default display format (as specified on the Inspector's Data Formatting to be dd/mm/yy. Without touching that it is "As Entered" and it displays as mm/dd/yyyy.

 

Share this post


Link to post
Share on other sites

I'm not sure that is possible on a US based system - it does that for me, in that format, because I'm Australian and that's my system default.

I know I used to have to open files locally and clone them to change from US default to Australian default - the cloned file would pick up my local formats

Share this post


Link to post
Share on other sites

Hi Barbara!

I feel your pain.  Data formatting is not handled by Styles.  What I do is have a developer layout where I store pre-defined fields such as dates, portals and other objects.  It is where I set up all my objects and can review my styles in one place.  I can also then increase the height of fields ( to allow for Windows display without cutting off text ) and I can set the date formatting, numbers etc.  I can then also set the width of the field for dates, along with drop-down calendar etc.  Then when I need a date field, I just copy/paste my date and re-point it to the correct field.

By keeping a sample of all objects, I can adhere to consistent 'styles' throughout.

Share this post


Link to post
Share on other sites
2 hours ago, LaRetta said:

I set up all my objects and can review my styles in one place

I do that too. I created a Starter Theme based on ISO Magazine’s (Re)Theming Solutions and using the Minimalist Theme.

Lee

Share this post


Link to post
Share on other sites

I have a Theme layout, too, lol. Using Matt P's Starter Theme technique. Just thought I'd ask to see if I was overlooking a way to set the default.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Poruchan
      Hi,
      I’d like to show days since last race for a horse where the first race returns 0. I played around with ‘last’ and ‘GetNthRecord’ but something went wrong. I had some problems with races where the horse was scratched, but I can live with that. 
      Thanks,
      Paul
    • By ash1474
      Hi, I am using this calculation in portal which calculates days in portal  Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
      how can i modify or do something else to avoid (?) in the first row.  Sample file attached for any modification/help.
      Thanks for any help
      DateCalc.fmp12
    • By tstark
      I have been using the Scribe plugin to insert text into word-based tables as part of an annual report.  I am using FM 16 on both Mac and Windows and have the very latest version of the Plugin.
      I am able to insert the text into multiple tables throughout the document quite well.  What is not happening is that the new data is not maintaining the formatting of the table.  I would be fine with just holding the correct font and size. 
      Should the data insert into the word based tables retain the formatting and if so what determines that formatting because inserting the data into a fully preformatted table removes all the formatting and sets the data back to some kind of default font of Cambria 12 vs. the Helvetica 9 that is in the table?
      Any Thoughts?
      Thanks,
      Todd
    • By Ponderosa
      So there's probably something simple, but do you guys know of a way to automate dates from one record to the next? Each record date needs to be seven days after the previous one, and I'd like for my client not to have to enter it manually. I tried doing
      Let ( Today = ( ReleaseDate ) ;

      Date ( Month ( Today ) ; Day ( Today ) + 7 ; Year ( Today ) )

       
      and some others, but none appear to automatically fill in. Help!
    • By KassK
      Hi
      I am hoping someone can help me to do the below.
      I have two fields 1 "Letter Sent" field(date) and 2 "Letter Received" field (date). I would like the "Letter Received" field to go red if no dated entered 7 days after the date entered in "Letter Sent" field.
      I hope that makes sense.
×

Important Information

By using this site, you agree to our Terms of Use.