How to format SIL custom field?

rahuldanwade
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 29, 2016

I have two custom fields (date & time picker type)

I'm taking the difference between them and storing it in SIL custom field.

Typically it showing the result as JIRA work log format

For ex: -

A - 28/Jun/16 10:40 AM

B - 28/Jun/16 10:38 AM

number C = A-B

C = 1m 57s

What I wanted to populate is the result of routine 

floor(C , 1)

so that it can be rounded off to 1m but it is not working SIL field displaying 0d.

Basically, all I want is to get rid of seconds part and display only d,w,h,m

Please suggest solution


Thanks

Rahul

 

1 answer

1 accepted

0 votes
Answer accepted
rahuldanwade
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 29, 2016

I got the solution by myself.

some type conversions and I nailed it.

 

FlorinM
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 30, 2016

Great to hear that! Please note that intervals in SIL are 24h/day 7days/week.

Suggest an answer

Log in or Sign up to answer