How to solve MMM date issue without modifying source
It is pretty well known that Delphi's StrToDateTime doesn't convert a
character based date (ie. 15/Sep/2014). It only understands numbers.
Embarcadero has not updated this function to correct this and instead
have suggested using VarToDateTime which does properly handle this.
However the AutoSearch and SQL building in ReportBuilder only uses
StrToDateTime, so a regional setting of dd-MMM-yy (one of the selectable
US options) breaks autosearch and the generation of SQL. Has anyone
found a workaround for this short of a .PAS fix?
Thanks,
Rhett Price
IndySoft
character based date (ie. 15/Sep/2014). It only understands numbers.
Embarcadero has not updated this function to correct this and instead
have suggested using VarToDateTime which does properly handle this.
However the AutoSearch and SQL building in ReportBuilder only uses
StrToDateTime, so a regional setting of dd-MMM-yy (one of the selectable
US options) breaks autosearch and the generation of SQL. Has anyone
found a workaround for this short of a .PAS fix?
Thanks,
Rhett Price
IndySoft
This discussion has been closed.
Comments
You opened this issue via email and our correspondence is ongoing - I will
be following up with you. Please do not post here about the same issue.
TIA,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
]
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com