Details about this thread
  • State Not Answered
  • Replies 1 reply
  • Subscribers 314 subscribers
  • Views 64 views
  • Users 0 members are here
Related content from around SugarClub

How do I format a related date field to DD-MM-YY

Jaymie Raymond

Hi

Thank you for your advice and help in advance. 

I am using document templates to pull together fields from the RLI module as well as some related ones. The field below is from the module 'Issues".

I want to return the deadline_c field in the format of DD-MM-YYYY but I must be misunderstanding the structure. I used this for {!date format='DD-MM-YYYY'} and it worked.

{!formula value='related($is_issues_revenuelineitems_1, "deadline_c” format='DD-MM-YYYY')}


Works but shows the format as YYYY-MM-DD

{!formula value='related($is_issues_revenuelineitems_1, "deadline_c”)}

Again thank you for any help in advance.

thanks

Jay

Parents
  • 0 Sugar Employee Badge

    Helo  , 

    Thanks for sharing this!

    Are you using Doc Merge? If so, could you share the exact formulas you are saving in the document?

    Based on your description, I suspect you might be encountering the issue described in the following report:

    #95610 ( portal.sugarondemand.com/ )

    The issue occurs when selecting a date format from the formula picker—where the selected format is not properly copied over.

    A workaround is to manually specify the format in the document, like this:

    {date_field_name format='MM-DD-YYYY'} i


    Can you clarify if this is what you are facing? 
    I hope this helps.

    Cheers, 

    André 

Reply
  • 0 Sugar Employee Badge

    Helo  , 

    Thanks for sharing this!

    Are you using Doc Merge? If so, could you share the exact formulas you are saving in the document?

    Based on your description, I suspect you might be encountering the issue described in the following report:

    #95610 ( portal.sugarondemand.com/ )

    The issue occurs when selecting a date format from the formula picker—where the selected format is not properly copied over.

    A workaround is to manually specify the format in the document, like this:

    {date_field_name format='MM-DD-YYYY'} i


    Can you clarify if this is what you are facing? 
    I hope this helps.

    Cheers, 

    André 

Children
No Data