Confiforms - How to copy EPOC from date field and paste into ReadOnly field formatting as yyy-MM-dd

Question

Hello all! I'm trying to copy an EPOC value obtained from a Date field into a ReadOnly field  so I can store that into a table. The value that's returned is an EPOC value. Any way I can update the ReadOnly field with the date string of "yyy-MM-dd"? How do I convert the EPOC value into a string that can be copied into the RO field. So far I have not found a function that deal with EPOC to date string conversion.

Here is what I'm trying to do...

Date Field 1: Date selector formatted as yyyy-MM-dd

Date Field 2: ReadOnly field

Update Date Field 2 with value from Date Field 1 while adding 7 days to the value and then updating Date Field 2 and have it displayed like "yyyy-MM-dd"

I am totally new to confiforms, so this is a learning on the job experience.

Thank you.

Glen

Alex Medved _ConfiForms_ · Answer

You can use formatDate on your "epoc" holding field - https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

Note that functions and transformations could be applied realtime, so it is very rare when you need to copy the field's value into some other field, but could use it directly

See this quick demo:

http://recordit.co/6J9lAEGLVv

(as a bonus I have also jiraDateTime function used... dont get confused too much. This function is just a shortcut to formatDate function, but with special pattern)

Alex

Glen Collins_txqz3m · Answer

I answered my own question. After turning on debug I found it was converting the value that I wanted but found out it was not updating the field properly. I had the wrong variables trying to assigned to the field.