Date field with year less than 100


I have a problem with date field.

In one of my reports I have plain frxMemoView field that display date from some table "[SomeTable."DateField]". I don't use display formatting, so display format on that field is "Text(no formatting)".

When I have dates like "01.01.2021", "10.10.2020", "01.12.1999" everything works without errors, even years like "01.01.0100", '01.01.0101" or "01.01.0999" works OK. Display is "01.01.100", "01.01.101", 01.01.999".

When I have dates that have year less than 100, for example "01.01.0099" or "01.01.0020" then I've got error "Invalid argument".

When I set display format to some date (for example "") on that field, then there are no errors and years are displayed with 4 number years "01.01.0099" or "01.01.0020".

Is this expected behaviour or there should be no errors on field with no date formatting and dates with year less than 100?



Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.