I have a view that displays the year from the document thats a date/time field. The format is 2007/01/28.
The view column has a formulae that does and @right to get the year @Right(@Text(Date);4) , (before i get asked why do it this way, this is previous code written by someone else).
Anyway what happens is it actually converts correctly to 2007 …sometime for year and sometimes to 1/28.
My question is(for interest sake) does the notes view modify the presentation of the time/date field it sees based on the format of the Domino server? Is it not suppose retain the data as is in the notes document? And if its not retaining it correctly, could this be a possible bug?
thanks