A value that indicates a particular day and time, such as a timestamp.

learn more… | top users | synonyms

0
votes
0answers
11 views

Analytics - Date Formatting

Is there a way to change the format of a date field which has been imported from salesforce to analytics - the field shows: 2015-05-28T07:20:00.00Z in a raw data table and I want to change to a normal ...
-1
votes
1answer
35 views

What does LastModifiedDate<Last_N_Days:30 means?

Now this seems silly but I just can't get over this What will this query return? I'm getting confused at this line --> select ID,Name,LastModifiedDate from Account where ...
-1
votes
1answer
23 views

Invalid bind expression type of Datetime for column of type Date

for(Sample_Limit_vod__c SL : [select Account_vod__c, Product_vod__c, Disbursed_Quantity_vod__c, ...
0
votes
2answers
22 views

Last Modified date between 30 and 60 days formula

I have a requirement where I have to write a query with a condition that the Last Modified date should be between 30 and 60 days and this should be configurable by user. I have created a custom ...
1
vote
1answer
28 views

JSON.deserialize adding time

CalEvent calEvent = (CalEvent) JSON.deserialize(calEventJson, Technician_Dispatch_Util.CalEvent.class); System.debug('OGDEBUG TDU calEventJson '+calEventJson); System.debug('OGDEBUG TDU ...
2
votes
2answers
70 views

Convert Primitive dateTime to dateTime class

I am new in APEX and I am rapidly discovering the similarity to Java is skin-deep only. I am returning an sobject createDate field in a SOQL query, and according to the docs, the field is of ...
1
vote
2answers
82 views

Is it possible to use Apex Scheduler to run a batch class just once, 30 seconds after the scheduler is called?

I want to call a Schedulable class from within a trigger, to execute a batch job after waiting 30 seconds (or 5 seconds, as long as it's long enough to make absolutely sure the initial trigger ...
0
votes
0answers
14 views

Average number of hours between two dates and times in report

I have a report with the following columns: Date/Time Opened, Restore Communicated to Customer, Resolution Communicated to Customer and Date/Time Closed. I want to calculate the difference between ...
2
votes
0answers
29 views

ERROR(Save Error: duplicate Alias: Name) when using Day_Only

I'm using the following SOQL query to populate a custom controller for our sales team to view their opps on the opp tab landing page. It works fine with CloseDate alone, but the field is returned as ...
1
vote
1answer
25 views

Getting flow to reference a choice's “stored value” instead of its label

I have a flow containing a date/time selection screen comprised of a date picker and a dropdown field with different time values. Since I'm creating an Event I then have a formula field which puts the ...
1
vote
2answers
53 views

DateTime field = DateTime variable is losing the timezone

In short, I have built a very simple case builder in Apex/Visualforce where you select a case starting date (DateTime) and then it sets this value as the Estimated Start Date of the case (also ...
1
vote
2answers
33 views

Disable future dates in the Salesforce date picker?

Is it possible to disable future dates in the Salesforce date picker? If so, how can this be done?
2
votes
0answers
61 views

Timezone difference calculation [closed]

I have a requirement where the User's timezone might be in EST,PST or IST. Whenever an event is created for an Account, Start time of the event will be captured in the USER's timezone. But, there will ...
1
vote
1answer
59 views

Difference between two dates in hours excluding weekends [duplicate]

I'm looking for a formula to find out the difference between two dates (for example Business_date__c (date time field) and now() in hours, excluding weekends.
1
vote
3answers
31 views

What is the API Name of Remainder Field in Task?

I am creating a task via trigger which is working fine, but how to update this remainder field value via trigger. even in page layout also it is not visible and in "Task fields " also it is not ...
1
vote
2answers
149 views

DateTime field is showing one day lesser

I have one custom DateTime field named "Transaction Date". While inserting the records I am assigning today's date to Transaction Date.But when I see the record, Transaction Date value is a day ...
1
vote
0answers
26 views

How to create a Custom Pop Up for Task?

I want to create custom pop up for Tasks which will be opening on specified time . Because standard task pop up will only come for Day wise(Again it will calculate based on starting of the day) and I ...
2
votes
2answers
30 views

How to get the date on date/time record type

How can i get the date on the date/time record type. So that i can condition this if Start_Date_Time__c = End_Date_Time__c. If true the output is like this: Friday, 26 June 2015 from 9:00 AM to ...
2
votes
1answer
42 views

Modify Case Date/Time Opened Field on Upload

I'm trying to import some historical case data into our SalesForce account either through Bulk API or through Data Loader tool. I need to have the field "Date/Time Opened" under the new cases I am ...
1
vote
1answer
30 views

How to parse Setup Audit Trail's Date format

When looking at a record of the Setup Audit Trail, the date records have a format I can't seem to parse, due to the timezone not being unique - The records' dates are like: "22/06/2015 14:41:24 IST ...
2
votes
2answers
327 views

Issue with Datetime.format('MM/DD/YYYY')

I have date field "dt" which debug like '2015-06-25', and I have to change the format like 06/25/2015. Since we can't use .format('MM/DD/YYYY') on date field. I have converted it to DateTime. ...
2
votes
1answer
46 views

Combine Date from one datetime field with Time from another

I have tried all sorts of proposed solutions but can't seem to find one that works. I receive 2 DateTime fields from an api call and need to take the Date part from one and combine it with the Time ...
2
votes
1answer
127 views

System.TypeException: Invalid date: 2015-06-04

If I changed the time zone in Salesforce Org then getting the 'Invalid date Error'. It works fine if I select the Indian time zone but If I select other than current Timezone then Displaying error ...
2
votes
2answers
36 views

Java sql.TimeStamp to Salesforce

I have a Java mapping that takes a field of type java.sql.Timestamp and insert it into Salesforce. Example of a field in the db: 2013-10-17 13:01:01 When it is inserted into Salesforce it looks ...
1
vote
1answer
41 views

Capturing Only Date & Month for a Date in Salesforce

We have a requirement to capture only "Date" & "Month" for a field (for e.g. Birth Date). We don't want to capture birth year. I think the best way to capture this in Salesforce would be by ...
4
votes
1answer
121 views

How to format today's date in this format?

How can we format today's date in the following date/time format? 2015-04-29T06:17:44.000-07:00 it represents yyyy-mm-ddThh:mm:sss-UTC any suggestions will be appreciated. Thanks in advance.
0
votes
1answer
65 views

How can I convert string 2015-04-15T12:48:00+05:30 to Salesforce DateTime format?

How can I convert string 2015-04-15T12:48:00+05:30 to Salesforce DateTime format? And also adjust the Timezone to be set to GMT +05:30?
1
vote
3answers
395 views

Use JavaScript functions on a Visualforce page

I am using a DateTime field on a Visualforce page which gets its value from the controller. I would like to know if I can use JavaScript or jQuery code directly on the Visualforce page to convert this ...
1
vote
0answers
48 views

Inaccurate count of weekdays for the month of March

Is there a reason why counting the days of the month of March is inaccurate? This is the method in counting the weekdays: public integer GetWeekDays(Datetime startDatetime, Datetime endDatetime) { ...
0
votes
2answers
423 views

Converting a Date from yyyy/mm/dd to mm/dd/yyyy including GMT Timestamp

String dateTimeString = '1970-01-08T23:45:27.461Z'; dateTimeString = dateTimeString.substring(0, dateTimeString.indexOf('.')); system.debug('dateTimeString'+dateTimeString); results in ...
2
votes
1answer
232 views

Formula Fields in Process Builder

I was trying to replicate the workaround for not being able to put a Now formula into a Process Builder action as found here: setting current date/time in process builder I created a formula field ...
3
votes
1answer
125 views

How to convert date time to date

On a http call response i was getting date as 1970-01-08T23:45:27.461Z. Here i have to change it to date like 1970-01-08 ... need some ideas... when i tried to take Date type in wrapper classes ...
1
vote
3answers
99 views

format the DateTime in an inputField

Is there a simple way to display the dateTime in an inputfield using an alternative dateTime Format? Or is there an easy way to display a datepicker when clicking in a normal textfield input?
4
votes
1answer
279 views

Calculating date/time x working hours from now

I need to trigger an email notification 9 working hours after a particular field is changed in Salesforce. So if the field is changed on a Friday at 4pm, I need to calculate now() + 7 hours + an extra ...
1
vote
3answers
393 views

setting current date/time in process builder

I'm trying to figure out if process builder can update a field to the current date/time when the criteria is meet. I want to track when an opportunity stage is selected. I know the tracking in down ...
1
vote
1answer
52 views

How to set Local Time when creating lead through API

I have a rails app that needs to occasionally add leads to our salesforce account. I got it to work just fine using the databasedotcom gem. Just one thing isn't working correctly, when I add a lead ...
0
votes
0answers
29 views

Process.Plugin Data Type Conversions Date invalid conversion at runtime

I am getting this error when i run a flow with a Apex Plugin Class that has input parameters for type Date. This is used in conjunction with a Flow. Error Message: System.TypeException: Invalid ...
1
vote
1answer
74 views

Using a custom formula field to create a timezone adjusted field using an existing datetime and timezone field

We would like to use an email alert to automate demo reminder emails for our prospects. We currently have a Demo Meeting Time field (datetime) and a Timezone field (text) to reference in a formula ...
1
vote
0answers
30 views

Standard DatePicker always set empty

We have some date fields in VF pages which were working fine. Suddenly some of them are not working. When user select the date from date picker, always it sets empty string to the textbox. ATM ...
1
vote
1answer
57 views

Workflow date/time criteria

I have a date/time field that store when an email was sent. I then want to have a workflow that resets another field on the record the next time the record is edited AND it is within a certain time ...
1
vote
0answers
18 views

DateTime: was there a (silent) change in the math for DateTime calculations in formulas?

In Summer'14 (likely also in Winter'14) there was a very special behavior of the platform to deal with precise datetime calculations as described here: Duration as difference betweed to Datetime ...
1
vote
1answer
46 views

DateTime Fields: is there and hidden feature / option to display seconds? Always?

I need to dive into precise time calculation and monitoring on the level of seconds. As it stands, Salesforce is managing internally seconds for DateTime. But - and this is very sad - the entire UI ...
12
votes
4answers
304 views

What is the purpose of Datetime.dateGmt() function?

In casual testing, I can see these give different results: //assemble from component parts Datetime now = System.now(); Date today = Date.newInstance(now.yearGmt(), now.monthGmt(), now.dayGmt()); ...
0
votes
1answer
215 views

Convert Datetime of one Timezone to Datetime of another TimeZone

There are lot of questions regarding the date-time conversions but need the right way to do it. My requirement is to take the user Input "DateTime" from a field and convert it to the specified ...
-1
votes
1answer
116 views

need to store date time based on customer timezone

Is it possible to calculate the timezone based on the country/state field value of a record? If so how? Is it possible to display the time field with the timezone it relates to? If so how?
0
votes
1answer
49 views

Convert A String to Unix Date format

I have a String stored as a Label in this format : 2014, 8, 01, 0, 0, 0. This is eventually meant to return a UNIX_TIME_STAMP. So I tried the following : private static final String myDate = ...
2
votes
2answers
962 views

visualforce page display time in timezone

I have a email alert that uses a Visualforce email template to generate an email with a date/time field that I want my to display as GMT, currently the time displayed in the email is offset by the ...
1
vote
1answer
23 views

Query Records “where MyCustom__Date__c.Month()=1”

I want the records where MyCustom_Date__c month is = January. Where my field MyCustom_Date__C is formula field lst="select Name from CustomObj__c where MyCustom__Date__c.month() = : 1" Its giving ...
0
votes
1answer
294 views

How to convert string into datetime format?

Hello Everyone I'm new in sales force and I want to change datetime format so that first of all I got datetime and after that I have convert it to string with different format . Now I want to again ...
1
vote
1answer
284 views

Set Default Value in a Formula Date/Time Field

I am looking to create a formula date/time field that will give me for example 12/05/2014 3:00 PM for today and then tomorrow it changes to 12/06/2014 3:00 PM. The date but not the time will change ...