Date field with year less than 100

Hello.

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 "dd.mm.yyyy") 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?

Thanks.

Sasa.

Leave a Comment