Calculate the difference between two DateTimes in Salesforce
- Dec
- 25
- Posted by Lin
- Posted in APEX, Other, Salesforce, Visualforce
In Formula Calculate the second difference between two DateTimes. In Visualforce Page Calculate the second difference between two DateTimes. In Apex ※A “Date/time arithmetic expressions must use Integer, Decimal or Double arguments” error will be occurred, when we subtract between two DateTimes directly like Formula.
read moreDisplay DateTime with TimeZone in Visualforce Page
- Jul
- 24
- Posted by Lin
- Posted in APEX, Salesforce, Visualforce
In Salesforce,Date and Date/Time values are stored in GMT,and a GMT time will be outputed when we use apex:outputText tag. e.g. Result ※Time Zone : (GMT+09:00) Japan Standard Time (Asia/Tokyo) As we know,we can not determine a user’s time zone in a formula,but there has two ways to fix this with Apex,maybe more. 1.Get User […]
read moreDate format and DateTime format
- Apr
- 24
- Posted by Lin
- Posted in APEX, Salesforce, Visualforce
Date format in Apex 1.Use Date format method 2.Convert to String directly 3.Convert to DateTime DateTime format in Apex Date format in VF DateTime format in VF Date format in Formula DateTime format in Formula TZoffset is the difference between the user’s time zone and GMT。 When in Tokyo:TZoffset = “9/24” Reference : https://help.salesforce.com/help/pdfs/en/formula_date_time_tipsheet.pdf
read moreRecent Posts
- Salesforce DevTools Release Notes (version 3.10.0) – mass edit custom fields on lightning
- Salesforce DevTools Release Notes (version 3.9.0) – Object Fields, SOQL Query Editor
- Salesforce DevTools Release Notes (version 3.8.0)
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- Using Promise for Apex Server-Side request in Lightning Component
Top Posts
- Salesforce DevTools – Powerful Salesforce developer tools, loved by over 50K developers - 217.7K views
- Date format and DateTime format - 201.9K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 157.5K views
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 121.8K views
- Writing a Schedulable Batch Apex in Salesforce - 116.9K views
Categories
- APEX
- Apps
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- Event
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DevTools
- Salesforce DX
- SOQL
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress
You must be logged in to post a comment.