Submitted by Tom on 2009/01/07 07:23
I havent used these fields in a long time but they worked last time used ...
 
Changed (YES/NO field) should change colour of item and add date to DateChanged field
-
it no longer adds the date to DateChanged field
 
Equation for Changed is
A:DateChanged=int(date)|E:DateChanged= |AM: ItemColor="darkblue" | E:ItemColor="yellow"
 
so the first bit isnt working - I notice there's no space between first & second parts [...date)|E:Date...]
so I tried adding a space there but it's still not working (even after restart)
 
DateChanged is a date field
Default Value  =int(now())
Equation:  yy-MM-dd
 
 
Any ideas on what might have gone wrong?

Comments

>Equation for Changed is
A:DateChanged=int(date)|E:DateChanged= |AM: ItemColor="darkblue" | E:ItemColor="yellow"
 
Most likely the issue is A:DateChanged=int(date). It should read A:DateChanged=int(now())

Tom

2009/01/07 08:23

Permalink

[quote=Pierre_Admin]
Most likely the issue is A:DateChanged=int(date). It should read A:DateChanged=int(now())
[/quote]
 
will try that out - I know that  =int(now())   also gives current time which I'd prefer not to have (but can live with!)

Pierre_Admin

2009/01/07 08:26

Permalink

  • now() includes the time
  • int(now()) strips away the time

Tom

2009/01/07 08:30

Permalink

[quote=Pierre_Admin]
  • now() includes the time
  • int(now()) strips away the time
[/quote]
 
works a treat, thanks!!