Conner Posted June 1, 2006 Posted June 1, 2006 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
Lee Smith Posted June 1, 2006 Posted June 1, 2006 Auto Enter is upon record creation feature. change the field to a Calculation field. and choose the unstored calculation option. HTH Lee
Razumovsky Posted June 1, 2006 Posted June 1, 2006 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
Conner Posted June 2, 2006 Author Posted June 2, 2006 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
Razumovsky Posted June 2, 2006 Posted June 2, 2006 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?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now