Hello,
I am trying out Softr Databases, and was trying out the date fields.
I saw that you could convert from string to a date field with the formulas.
So I tried DATETIME_PARSE({my_text_field}, “DD-MM-YYYY”) and it didn’t work. It results in an empty field, no errors, nothing.
The field is of the short text format and I had inputted “20-05-1995”.
Thanks.
I initially thought there might have been a formatting issues causing the blank field. So I tried copying and pasting the example from the Softr help docs and it didn’t work either. There certainly seems to be something wrong with this formula.
Yeah… However when using the other Date formulas such as Date diff, with a text field, using “31-12-2025” seems to work as a temporary fix.
Hi there,
There was a bug, which we just fixed. But when you’re doing this, make sure you use the format: dd-MM-yyyy
Thanks for the fix!
I should perhaps create a new thread… But there seems to be another Date related formula bug
DATETIME_FORMAT(LAST_MODIFIED_TIME({Status}), "MM/DD/YYYY")
Just tried this, copy paste from your docs. Returning blank.
I don’t think LAST_MODIFIED_TIME({Status}) works…?
should be LAST_MODIFIED_TIME()
I am trying to get the last modified time for a specific field as specified in your docs. Perhaps this is not possible?
It’s a mistake in docs it can’t do on field level it’s on record level
Ahh okay, thanks!
Would be nice to have it on field level too 
