Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6811 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a field that shows the current date on creation (via Auto-Enter), but I want that field to always show the current date.

So, when tomorrow rolls around, I want this field to show that date.

Any tips?

-Conner

Posted

Auto Enter is upon record creation feature. change the field to a Calculation field. and choose the unstored calculation option.

HTH

Lee

Posted

If you only need to view the date, you can do this without a field. Enter layout mode and type "//" on the layout - that will always display the current date in browse mode.

-Raz

Posted

Thank you, Lee & Raz. You are the best.

I did know about the "//", but several Scripts need to look at the date as a field.

Changing the field to a calculation and selecting unstored did work (I have no idea why "unstored" matters).

-Conner

Posted

several Scripts need to look at the date as a field.

I am having a hard time imagining why you would need this as a separate field when you could gather this information at any point during a script using the get(currentDate) function. Unstored just means that the value is constantly recalculated - this also means that it involves a lot more computing than stored fields, and can slow things down. Why not just look up that data when you need it instead of having a field constantly working it out for all records all the time?

This topic is 6811 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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