Skip to main content
Topics#Data ManagementFrage von Wallace Choi
Wallace Choi fragte in #Data Management
23. Okt. 2013, 12:06

How to build formula of a custom link with formatted date field?

I need to build a custom link in the Account object that allows user to access a file from a remote site. Part of the URL requires an argument of date on previous month. Below is the example URL and the description of the arguments. Could you tell me I can build the link?

 

Example URL: http://www.abcde.com/enAA/YYYYMM_AABBB.pdf

 

AABBB - Company Code

 

YYYYMM - Year-Month of previous month

 

If company code is 12345 and current date is October 2013, the URL should be http://www.abcde.com/en12/201309_12345.pdf
7 Antworten
  1. Vamsi Gosu (TechForce Services)
    23. Okt. 2013, 12:43
    just noticed that i missed to add the leading 0 for the month part..

     

    you can simply alter the case statement to prefix a 0 for the month if its mandatory for you.
Antwort schreiben...
0/9000