function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
myat myatmyat myat 

datetime.format

I try to format below datetime and getting incorrect return. any idea?

datetime date1 = datetime.newInstance(2018, 12, 29) ;
datetime date2 = datetime.newInstance(2018, 12, 30) ;
datetime date3 = datetime.newInstance(2018, 12, 31) ;

system.debug('date1 ==>' + date1 + ' = ' + date1.format('dd MMMM YYYY'));
system.debug('date2 ==>' + date2 + ' = ' + date2.format('dd MMMM YYYY'));
system.debug('date3 ==>' + date3 + ' = ' + date3.format('dd MMMM YYYY'));

debug log:
date1 ==>2018-12-28 17:30:00 = 29 December 2018
date2 ==>2018-12-29 17:30:00 = 30 December 2019
date3 ==>2018-12-30 17:30:00 = 31 December 2019

Thank you.



 
Best Answer chosen by myat myat
Raj VakatiRaj Vakati
try this code
  
datetime date1 = datetime.newInstance(2018, 12, 29) ;
datetime date2 = datetime.newInstance(2018, 12, 30) ;
datetime date3 = datetime.newInstance(2018, 12, 31) ;

system.debug('date1 ==>' + date1 + ' = ' + date1.format('dd MMMM yyyy'));
system.debug('date2 ==>' + date2 + ' = ' + date2.format('dd MMMM yyyy'));
system.debug('date3 ==>' + date3 + ' = ' + date3.format('dd MMMM yyyy'));

 

All Answers

Raj VakatiRaj Vakati
It will be based on the org time zone .. please check the time zone of the org and see the values of dates ...
myat myatmyat myat
Hi Raj,

The org timezone is "Asia/Rangoon" and the date in the record itselt is "31/12/2018". But when formated in (dd MMMM YYYY'), becomes "31 December 2019"

thanks.
Raj VakatiRaj Vakati
try this code
  
datetime date1 = datetime.newInstance(2018, 12, 29) ;
datetime date2 = datetime.newInstance(2018, 12, 30) ;
datetime date3 = datetime.newInstance(2018, 12, 31) ;

system.debug('date1 ==>' + date1 + ' = ' + date1.format('dd MMMM yyyy'));
system.debug('date2 ==>' + date2 + ' = ' + date2.format('dd MMMM yyyy'));
system.debug('date3 ==>' + date3 + ' = ' + date3.format('dd MMMM yyyy'));

 
This was selected as the best answer
myat myatmyat myat
Hi Raj,

Thanks. It works. Do you have any documents/resources to referce for those date format?