Prism Release 2

I've fixed a validation issue in the Formula Tool where date values were sometimes treated as plain text during comparisons.

This caused incorrect warnings like “cannot compare date to string” even when users entered valid date values.

With this update, date and datetime comparisons now work correctly across a much wider range of common date formats, so users can write conditions more confidently without unnecessary validation errors.

Supported formats now include:

• day, dd Month, yyyy
• dd-MM-yy
• dd-MM-yyyy
• dd Month, yyyy
• dd/MM/yy
• dd/MM/yyyy
• day, Month dd, yyyy
• MM-dd-yy
• MM/dd/yy
• MM-dd-yyyy
• MM/dd/yyyy
• Mon dd
• Month dd, yyyy
• Month, yyyy
• yyyy-MM-dd
• yyyyMMdd
• yyyy-MM-dd hh:mm:ss