Hi All,
I had this function working in an old project, but it was a while ago and was probably on a different DB and server type.
Currently, on a NodeJS server and PostgreSQL DB, the ‘dateAdd’ formatter does not work on a TIME field that is being returned by a DB query.
If I try to set a value (to test it) and apply the dateAdd formatter, it simply does not return any value (not even an empty value)
The same thing happens if I try to apply the formatDate function, once if apply it to a TIME field values or server values, it does not out put any result.
It will only work if the DB field type is dateTime and not just time.
Is this a bug or working as its meant to?
It seems a bug as i want to be able to manipulate the time field in a server action but now have to change it to a dateTime field and make every time have the same date just to perform dateAdd functions.
Input appreciated 
Last updated: