Peoplesoft Peoplecode Stuff

Search This Blog

Date Format for Insert in DATAMOVER

Posted by die van niekerkuu's on November 08, 2015

Get link
Facebook
X
Pinterest
Email
Other Apps

to_date('19000101','YYYYMMDD')

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

UnknownMarch 12, 2016 at 5:11 AM
T20 World cup 2016 Live Streaming
icc t20 wc live score
World T20 2016 Schedule
India vs Australia t20 World Cup 2016 live score
Iindia vs South Africa T20 world Cup 2016 live
India vs West Indies world T20 Live Score
India vs Bangladesh World T20 Live Score
India vs Pakistan live streaming
T20 World Cup 2016 live score board
Women world T20 2016 Schedule
West Indies Vs England world T20 live streaming
India vs New Zealand world T20 live streaming
India vs New Zealand world T20 live streaming
Pakistan vs India world T20 Live Score
India vs Sri lanka World T20 Live Score
South Africa Vs England world T20 live streaming
Australia vs New Zealand world T20 live streaming
South Africa vs West Indies world T20 live streaming
New Zealand vs Pakistan world T20 live streaming

ReplyDelete
Replies

Add comment

SendMail with PT_MCF_MAIL (multiple attachments)

import PT_MCF_MAIL:*; /**** Send Mail ****/ Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail(); &email.From = " PSCSMPRA@up.ac.za "; SQLExec("select EMAILID from PSUSEREMAIL where OPRID=:1 and Primary_email = 'Y'", %OperatorId, &Email_To); &email.Recipients = &Email_To; &email.Subject = %DbName | ": Update Dual Class Sections to English"; Local string &plain_text = "Please see report output attached for Class Section update from Dual to English (D100 to E100)."; Local PT_MCF_MAIL:MCFBodyPart &text = create PT_MCF_MAIL:MCFBodyPart(); &text.Text = &plain_text; &File_name_path = GetCwd() | "\files\Dual_UpdatedTo_English.csv"; &file_name_email = "Dual_UpdatedTo_English.csv"; &File_name_path2 = GetCwd() | "\files\English_ClassSection_Exist.csv"; &file_name_email2 = "English_ClassSection_Exist.csv"; Local PT_MC

BI Publisher little tricks

While creating a BI Publisher Invoice report for a client I had to google like a mad women. Here are some of the things I've learned: The template consists of 2 pages because one of the requirements was a remittance advice at the end of each invoice (per student) - almost like a footer but only on the last page. This was the final .rtf template: The body of the template looked like this: Tips: 1. Formatting the date: <?format-date:A.DATE_DUE;'dd/mm/yyyy';'UTC'?> 2. Formatting the amounts: <?format-number:A.TOT_FUTURE_AMT;'999G999D99'?> 3. Calculating the sum of the current group: <?sum(current-group()//EXPR64_64)?> 4. If statements: <?if:sum(current-group()//A.DEBIT_UFS)<0.00?><?sum(current-group()//EXPR64_64)?><?end if?> OR <?if:A.TOT_FUTURE_AMT!=0.00?> 5. Upper Case: <?xdofx:upper(A.NAME_TITLE)?> Because of the last page "footer" both pa

Powered by Blogger

Date Format for Insert in DATAMOVER

Comments

Post a Comment