Hi all - I have read a few posts on this but I can’t quite work out how to achieve something I thought would be achieveble through changing the initial content of a field.
I load a form and add two date/times from which I calculate a duration (say an hour) and a duration minus 15 minutes (it isn’t always 15 minutes but this is immaterial). I write the two date/times away and that al works fine.
When I want to amend the record I read back the two date/times and calculate the duration again (as I don’t store this) and I also calculate the duration minus 15 minutes and display it. This all works fine.
However when I change the one of the date/times I need to recalculate the time again so effectively I need to change the ‘intial content’ in some way. I don’t want to save the start and end dates transiently in the DB if I can help it.
Any words of widsom?
UPDATE: Sorted it without having to change anything
Thanks