Can you attach a screenshot showing us the missing date in the portal?
Thanks for a quick response
here are a few screen shots
from Diary - 30/11
List of transactions for those two dates
relationship diagram in Diary database
These two show both date fields are designated as Date, without forcing the 4 digit year.
Also, I have checked other firsts of the month and they also have transactions missing from the portal
Oh me miserum!!
I have found my issue. I am hiding the fields with a comparison against a date - but I was not using the ‘getasdate’ function so every now and then the calculation was giving the incorrect answer. Had it occurred more times and I am sure I would have spotted it earlier.
Sorry to have wasted your time.