I’m trying to figure out if process builder can update a field to the current date/time when the criteria is meet.
So I have a visualforce page displaying a query. But when it is being display on a force.com sites page. The created dates are different.
I am having trouble in finding the difference between 2 datetime variables and reducing the offset timezone difference in order to get the local time from the salesforce generated GMT time.
I have a requirement to find the difference between 2 datetime field in terms of hours and minutes.
My time zone is EST and sometimes i was asked to calculate for CST as well, how can this be done?
I opened a case with Salesforce (#08078994), but their Support Engineer has claimed repeatedly that, “I have reconfirmed and there is no issue with Date Time methods. The issue which you are notifying to us is related to coding done by you.”
I feel that the following assertion should be true, but it is not:
What do I need to add to my code to change the date format from ‘DD-MM-YYYY HH: MM: SS’ to ‘DD-MM-YYYY’
I am trying to query the
PurchaseDate datetime column from
tmp table along with a custom column that is
PurchaseDate column with time as 00:00:00 / midnight:
I have a table (DTP) with a simple structure and around 200k rows
I’m trying to SELECT rows that matches datetime in my column. I have a table containing mDTS set as DATETIME (with no curly braces).
My table looks something like this: