Wednesday, December 6, 2023

Date format and DateTime format in Salesforce

 Hello friends today we will discuss about Data and Date Time format into Salesforce with some sample code 

Date format in Apex

1.Use Date format method

String dateStr = Date.today().format();
System.debug('>>>>' + dateStr);
System.assertEquals(dateStr, '4/24/2015');
view rawdate.java hosted with ❤ by GitHub

2.Convert to String directly

Date dToday = Date.today();
String dateStr = dToday.year() + '/' + dToday.month() + '/' + dToday.day();
System.debug('>>>>' + dateStr);
System.assertEquals(dateStr, '2015/4/24');
view rawdate.java hosted with ❤ by GitHub

3.Convert to DateTime

Date dToday = Date.today();
String dateStr = Date.today().format();
DateTime dt = DateTime.newInstance(dToday.year(), dToday.month(),dToday.day());
String dateStr = dt.format('yyyy/MM/dd');
System.debug('>>>>' + dateStr);
System.assertEquals(dateStr, '2015/04/24');
view rawdate.java hosted with ❤ by GitHub

DateTime format in Apex

DateTime dt = DateTime.now();
String dateTimeStr = dt.format('yyyy/MM/dd hh:mm:ss');
System.debug('>>>>' + dateTimeStr);

Date format in VF

<apex:outputText value="{0,date,yyyy/MM/dd}">
<apex:param value="{!TODAY()}" />
</apex:outputText>
view rawDate.html hosted with ❤ by GitHub

DateTime format in VF

<apex:outputText value="{0,date,yyyy/MM/dd HH:mm:ss}">
<apex:param value="{!NOW()}" />
</apex:outputText>
view rawDate.html hosted with ❤ by GitHub

Date format in Formula

TEXT(YEAR(TODAY())) + "/" + TEXT(MONTH(TODAY())) + "/" + TEXT(DAY(TODAY()))
view rawDate.js hosted with ❤ by GitHub

DateTime format in Formula

TEXT(MONTH(DATEVALUE(NOW())))+"/" +TEXT(DAY(DATEVALUE(NOW())))+"/" +TEXT(YEAR(DATEVALUE(NOW()))) & " " &
MID(TEXT(NOW()-TZoffset), 12, 2) & ":" &
MID(TEXT(NOW()-TZoffset), 15, 2) & ":" &
MID(TEXT(NOW()-TZoffset ), 18, 2)
view rawDateTime.js hosted with ❤ by GitHub

No comments: