get(currentdate) refresh

[VICH]

i need a calc of some sort that defines a feild to current date (i have that part) but updates at midnight...or will i be forced to have a refresh script step

[LaRetta]

Hi VICH,

You can use Task Scheduler (in Control Panel) to run opening an FM file which has an opening script which can set your date and then close itself. You can schedule it to run at midnight. VBScript could also be used (I would bet) although I haven't used it in this way before.

LaRetta

[VICH]

hmm well let me put it like this, i have 12 date feilds the first has a calc value of get(currentdate) feild 2 is the date in feild 1 + 1

and then from then on its the previous date + 1, in order to show 12 consecutive days, at midnight the first feild has to update, and then the other 11 do as well, so what would be the best option

[Raybaudi]

Can I ask if someone works at midnight ?

[VICH]

yes you can and no they don't

[Raybaudi]

or will i be forced to have a refresh script step

So, based on your previous replay, you don't need a script to refresh the current date...

You only need to make UNSTORED the calc of ToDay = Get(CurrentDate)

[Raybaudi]

i have 12 date feilds the first has a calc value of get(currentdate) feild 2 is the date in feild 1 + 1 and then from then on its the previous date + 1, in order to show 12 consecutive days

Also I think that [color:red]here you can use those ill-famed repeating fields !

Make a 12 rep repeating field with this calc:

GetAsDate ( Extend ( ToDay ) + Get ( CalculationRepetitionNumber ) -1 )

where ToDay = Get(CurrentDate) UNSTORED !

[VICH]

i'll have to try that thanks buddy