3 Replies Latest reply on Dec 1, 2016 2:24 AM by florian1

    Subject Date/Time is SR

    Gazz Apprentice

      Hi

       

      I have added the required date to the subject line in when a SR is logged but would like to know how I remove the hour part (12:00 AM) to only display the date. I used the Date function on the offering form.

       

      New Distribution List - 11/26/2016 12:00:00 AM - gary.baney - tester 2

       

       

      Tx

        • 1. Re: Subject Date/Time is SR
          florian1 Expert

          Hi Gary,

           

          try this:

          $(FormatDate(CreatedDateTime, "dd.MM.yyyy", "Europe/Berlin"))
          
          

           

          HEAT Help: Reference > Using Built-In Functions > Date Functions > FormatDate

           

          Cheers,

          Florian

          • 2. Re: Subject Date/Time is SR
            julie.slattery@osr.nsw.gov.au Rookie

            Hi Gary,

            We have the same issue. The only way to fix is to use and extended task. It works for the date format but looks a mess. I can't find the correct sintax to get each date on a separate line .

             

            $("FES Database Refresh - " + GetSRPValue(RecId,  "Selectenvironment") +  " Database available for refresh " +  FormatDate(GetSRPValue(RecId,  "startdateofdbrefresh"),   "dd.MM.yyyy",   "Australia/Sydney") +  " Date Application available for Re-Directions - " +  FormatDate(GetSRPValue(RecId,  "Applicationavailave"),   "dd.MM.yyyy",   "Australia/Sydney") +  " Date production to be copied - " +  FormatDate(GetSRPValue(RecId,  "Productiondatetobecopied"),   "dd.MM.yyyy",   "Australia/Sydney") +  " Expected Start date of DB refresh - " +  FormatDate(GetSRPValue(RecId,  "startdateofdbrefresh"),   "dd.MM.yyyy",   "Australia/Sydney") +  " Expected completion date of DB refresh - - " +  FormatDate(GetSRPValue(RecId,  "ExpectedDBFinishdate"),   "dd.MM.yyyy",   "Australia/Sydney") +  " ")

             

            And this is what the tasks actually looks like .

            FES Database Refresh - UAT and BST Database available for refresh 27.12.2016 Date Application available for Re-Directions - 02.12.2016 Date production to be copied - 30.12.2016 Expected Start date of DB refresh - 27.12.2016 Expected completion date of DB refresh - - 30.12.2016

            1 of 1 people found this helpful
            • 3. Re: Subject Date/Time is SR
              florian1 Expert

              Yup, that's the way to go.

              For line feeds you just need to include \r (=CR) and \n (=LF):

               

              $("FES Database Refresh " + "\r\n"

              + " GetSRPValue(RecId,  "Selectenvironment") +  " Database available for refresh " +  FormatDate(GetSRPValue(RecId,  "startdateofdbrefresh"),  "dd.MM.yyyy",  "Australia/Sydney")

              + "\r\n" + " Date Application available for Re-Directions - " +  FormatDate(GetSRPValue(RecId,  "Applicationavailave"),  "dd.MM.yyyy",  "Australia/Sydney"))

               

              It will look like this:

              FES Database Refresh

              UAT and BST Database available for refresh 27.12.2016

              Date Application available for Re-Directions - 02.12.2016

              2 of 2 people found this helpful