refreshing field

[lenartpawel]

Hello, i have got a problem with dates...

i have got couple fields:

monday, sunday, week id and i want to change every time when i run filemaker, because for example in sunday everyting was OK but in monday (week id should change to next one, monday and sunday date too) it's not working until i change something in code!!!

How can i autorefresh this fields (this fields are in every record)

[Inky Phil]

From your description I haven't got a clue what you want to achieve but you can make any field update itself dynamically by making it a calculation field and check the 'do not store results' checkbox.

Using this method if you were to put the calculation

Get(Currentdate)+1

into a field it would always show tomorrows date.

An alternative method would be to run a startup script whenever you fire up FM and use a series of setfield script steps to set your fields to whatever you want them to be.

I do not know if that helps

Phil

[lenartpawel]

but you are sure it's going to change tommorow? even when i don't "click" on this field? (i should put this field as FIELD od MERGED FIELD)?

[LaRetta]

You need to provide more information. Did you try what was suggested? How will we know whether it works or not when we have no idea what you have? What are the field types?

[lenartpawel]

ok, so... i have got field:

monday = Get(CurrentDate)- DayOfWeek(Get (CurrentDate))+2 and it's display date of monday in this week (based in week id)

sunday = Get(CurrentDate)- DayOfWeek(Get (CurrentDate))+8 and it's display date of sunday in this week (based on week id)

weekid = Floor ((Get ( CurrentDate ) - ( Date ( 4 ; 1 ; Case ( Month ( Get ( CurrentDate ) ) < 4; Year (Get ( CurrentDate )) - 1 ; Year (Get ( CurrentDate ) ))) - DayOfWeek ( Date ( 4 ; 1 ; Case ( Month ( Get ( CurrentDate ) ) < 4; Year (Get ( CurrentDate )) - 1 ; Year (Get ( CurrentDate ) )))) +2 )) /7) and its display TAX WEEK ID... (p.s. now is 38 - in england)

and if i create a record, fields display weekid of week when i crate record! and if week is changed then in some records i have got previous weekid.

I'm sorry but i don't know how to explain it in english and sorry for my english!!

But i think "From your description I haven't got a clue what you want to achieve but you can make any field update itself dynamically by making it a calculation field and check the 'do not store results' checkbox." should work!!

Thx

Edited December 19, 2006 by Guest