10-04-2018 02:50 AM
Is there a way to change the default date format in a workflow,
for example I have a list that shows a field of type date; I want to show it in a format like 'dd-MM-YYY' as '4-october-2018'.
Solved! Go to Solution.
10-05-2018 05:07 AM - edited 10-05-2018 05:08 AM
One way to do this would be using a sqlselect on the field like (for postgres like below, sql server and oracle have different data formatting implementations):
You might need to set the field to type="textfield", datatype="string" for it to be displayed correctly.
If you need the field to have a datepicker for saving/editing the value, you could have one formfield visible="form", type="datetimepicker", datatype="datetime", and one non-persisted formfield visible="list" that has the sqlselect=".." statement, using type="textfield", datatype="string".
Hope this helps.