Date Calculation Anomaly

  • Here is a weird one. I deleted existing [to_date], then added a date calculation field to calculate the [to_date] from the [from_date]. In the field template placed the formula: [from_date]+[#5_days]=[?date]. Updated and looked at the Admin list which showed the number 0 (zero) for the To Dates. A page [pdb_list] showed [to_date]=[field_date].

    Next I changed the template formula to: [from_date]=[to_date]. Updated and the Admin list showed [to_date]=[from_date]+5 days. The page [pdb_list] still showed [to_date]=[field_date].

    Then I added the + 5 days back: [from_date]+[#5_days]=[?date]. Admin list showed [to_date]=[field_date] and [pdb_list] showed same still [to_date]=[field_date].

    ?????

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter erniemayberry

    (@erniemayberry)

    Update. I am not exactly sure what happened. I deleted the +5 days again and I added a non-related field, the admin list and the pdb_list are now both showing the [to_date]=[from_date]+5. So the admin list is still showing the desired result of +5 days after deleting the +5 from the template formula, but now at least the admin and pdb_list are showing the same.

    I guess this could be some caching issue, but I was pretty religous in flushing the site cache and chrome cache after each change.

    Thread Starter erniemayberry

    (@erniemayberry)

    Fixed it. Added back the formula with +[#5_days] and then re-entered the [from_dates] from the Admin List. As I reentered each from_date the to_date calculated correctly.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Date Calculation Anomaly’ is closed to new replies.