Pierre, you provided me this nifty equation
<source>SELECT ItemID, Format([Date],"ddd") AS DayFROM ¯qDate;</source>
which translates the date to a day of the week in a 2nd field
My assumption is that this equation sez
- IQ -- select the focused item source ID
- check for a date column
- if present
- format column date in format 'day of week'
This equation resides in a field named "Day"
I have an appointments grid and I have a GTD grid
in the appt grid, I have fields "apptdate" and "day"
the equation works well here however
I must refresh grid before day of week is inserted in the "day" field
In the GTD grid, I have fields "date" and "day"
the equation does not work in this grid
Why is this happening?
--
Jan Rifkinson
Ridgefield CT USA