Wednesday, 24 October 2012

Salesforce DateTime KeyCode



Letter Date or Time Piece Examples
G Era G = AD
y Year yy = 09, yyyy = 2009
M Month MM = 08, MMM = Aug, MMMMM = August
w Week in year w = 35
W Week in month W = 3
D Day in year D = 235
d Day in month dd = 27
F Day of week in month F = 2
E Day in week E = Thu, EEEEE = Thursday
a AM/PM a = AM or PM
H Hour in day (0-23) HH = 23
k Hour in day (1-24) kk = 24
K Hour in am/pm (0-11) KK=11
h Hour in am/pm (1-12) hh = 12
m Minutes in hour mm = 30
s Second in minute ss = 55
S Millisecond in second SSS = 888
z Time zone z = EDT, zzzzz = Eastern Daylight Time
Z Time zone offset Z = -0400



Example :
DateTime d = datetime.now();
dateTimeVal = d.format('MMMMM dd, yyyy hh:mm:ss a');
Output :
April 04, 2012 02:40:50 AM

How to Create Graph in Visualforce page Using Salesforce Data.

How to Create Graph in Visualforce page Using Salesforce Data.

Visaulforce page:


<apex:page extensions="ABC" standardController="Account"  sidebar="false" action="{!Method}">
  <apex:includeScript id="a" value="https://www.google.com/jsapi" />
    <div id="chartBlock"></div>
    <apex:outputPanel >
    <script type="text/javascript">
        google.load('visualization', '1.0', {'packages':['corechart']});
        google.setOnLoadCallback(drawChart);
                  function drawChart(){
          var visualization = new

google.visualization.ColumnChart(document.getElementById('chartBlock'));
          var data = new google.visualization.DataTable();
          data.addColumn('string', 'A');
          data.addColumn('number', 'B');
          data.addColumn('number', 'C');
          data.addColumn('number', 'D);
       
          <apex:repeat value="{!listabc}" var="r">  data.addRow(["{!r.A__c}",{!r.B__c},{!r.C__c},{!r.D__c}]);
          </apex:repeat>
         visualization.draw(data, {legend : {position: 'top', textStyle: {color: 'blue',fontSize: 10}},

width:window.innerWidth,vAxis:{textStyle:{fontSize: 10}},hAxis:{textStyle:{fontSize: 10},showTextEvery:1,slantedText:false}});
   }
   </script>
 </apex:outputPanel>


Controller: 

public  with sharing class ABC {

public List<Obj> listabc{get;set;}
public String accId{get;set;}


public ActualBudgetGraph(Apexpages.StandardController std) {
accId = std.getId();
}


public void Method(){
listabc =[Select A__c,B__c,C__c,D__c from  Obj  where id =:accId ];

}
}