Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

2 comments

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.

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

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

43,653 views 33 136
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you