Global Date Field !

[Anh_Tran]

Hi All,

I have a small question about global date field. The files are on server so we share data together. What I want to do is when i create a global date field. Let's say : 2003-11-03 and everyone can see the same date as I set it ... the date is not changed until i use the script ..setfield to change the date. How can I do it? ... I did what people say ... put the file off the server and create global date field .. but everyone has it own global date field ... I want everyone can see it the same and when need to be changed ... we use script setfield? ... Am I correct or do I miss something?

Any ideas experts?

Anh Tran

[Anh_Tran]

And also I heard that the global date field is the same date that I create and does not change ... I dont want it ... Is there a solution for above question?

Thanks

Anh Tran

[John Caballero]

Create a separate 1 record file that contains a regular (non-global) date field. Create a constant-to-constant relationship from your main file to this 1 record file. Create a calculated date field in your main file that evaluates the date field in the related file and use this calculated date field instead of the global. When you update the date in the 1 record file, all the records in the main file will show the update.

Obviously this field can't be indexed because it utilizes a relationship, so if you need to do searches on it, it could be painfully slow if your main file has many records.

[Anh_Tran]

Thanks John

Anh Phu