Questions tagged [datetime]
A value that indicates a particular day and time, such as a timestamp.
539
questions
2
votes
1answer
36 views
Datetime conversion from date vs explicit midnight
I've just spent two days banging my head against the Salesforce wall, and the problem came down to this:
Date wkStart = Date.newInstance(2019,10,12);
Datetime wkStart1 = wkStart;
Datetime wkStart2 = ...
0
votes
0answers
36 views
Event startDateTime shows more timestamp on Production
I have assigned custom timestamp to "starDateTime" standard field of event object by concatenating to custom date field but it shows additional 5:30 hours on Production.It works better in sandbox. I ...
2
votes
1answer
39 views
How to correctly convert Unix Timestamp with timezone offset into Apex Datetime?
There is a webservice which I'm trying to integrate in Salesforce. The webservice returns a date time in format like this
/Date(1569301200000-0500)/
I believe this is Unix Timestamp, and we can ...
2
votes
1answer
32 views
MC Connector createdDate transformation
I believe there are some date transformations applied automatically when synchronizing records from SFDC to MC via the Connector
I am talking about Created-date on Contact records for instance - I ...
0
votes
1answer
49 views
Formatting Dates and Time for SMS using AMPScript in Content Builder
Having a format issue on a SMS in Content Builder. Can someone point me to the correct code for this?
Also would love some advice to learn basic AMPScript coding. Books? Tutorials? Online classes?
...
3
votes
1answer
54 views
How to convert String to DateTime without time zone conversion?
I have a requirement to convert string value to DateTime without converting it to time zone.
Ex:
Datetime today = Datetime.now();
String myDate = today.format('yyyy-MM-dd HH:mm:ss');
Datetime ...
-3
votes
1answer
39 views
Get number of milliseconds since January 1, 1970, 00:00:00 UTC in apex [closed]
I want the apex equivalent of the following javascript method :
var utcDate3 = Date.UTC(2019, 7, 19, 18, 20, 5);
Because I need the number of milliseconds in the given Date object since January 1, ...
0
votes
0answers
21 views
Get LanguageLocaleKey based on timezone ID
I have a custom object called Machine__c and i have a custom picklist field in it called Time_Zone__c. This Time_Zone__c field has the same picklist values as the Standard User object timezone field.
...
0
votes
0answers
36 views
Converting String to Date
I have date format which is returned from JSON which i get in String, how do I convert it to Salesforce date format ? Does anyone have knowledge which date format is this ? Following is the date ...
0
votes
1answer
42 views
APEX test script to web server with a static time stamp doget cakk and HttpGet
New to writing test scripts. Looking for help in error in Unexpected token 'Lead' for my test code. I have a static field that pulls off time stamp to only pull data after a certain time. I am ...
0
votes
0answers
49 views
SQL to post + 30 days by Date/Time attribute
Goal is to find rows where the date is exactly 30 days from today.
Source is a Salesforce Date/Time field from a Synchronised Data Extension and posted to a regular Data Extension to Date attribute. ...
0
votes
1answer
48 views
Invalid Date Time
While trying to retrieve the headers from an integration response, I am getting a Datetime value in String format in the Header.
Format - Mon, 01 Jul 2019 10:20:06 GMT
I need to compare this with the ...
0
votes
1answer
30 views
Is there a way to detect actual user time zone (not Salesforce user acc.) in visualforce?
We have a "guest" form on our site, and a "guest" user to authenticate. Since the user has a set time zone, this is what (by default) is used by visualforce. Problem is, our Guest User will always be ...
0
votes
1answer
26 views
Can someone clear up datetime time zone behavior in visualforce email template?
Between the UI on direct records automatically adjusting to my time zone and not knowing default behavior in visualforce pages, I'm having trouble wrapping my head around what the user experience ...
1
vote
0answers
66 views
JSON time fields
We have a problem with deserialize and serialize salesforce time fields
Since Json and salesforce time fields both consist of "colon" we need to replace with a special character before deserialize ...
0
votes
1answer
69 views
How to disable the blue border around all the element after selecting a time in lightning:input of type datetime?
I have a lightning:input of type datetime
When I select a date it's ok, but when I select a time, after selecting during this "click" it's showing like a blue border around all the element.
I know ...
0
votes
1answer
120 views
LocalizationService formatDateTime method is not displaying correct time in European Time format
I am not getting expected output in time value. I am passing value as 20190619131800Z through query parameter and trying to format it according to Salesforce User Timezone. I am using lightning:...
0
votes
0answers
127 views
“INVALID_TYPE_ON_FIELD_IN_RECORD” while updating date/dateTime field using SOAP client
I have a SOAP client which connects with Salesforce and do CRUD operations.
Earlier I used to use Axis to generate stub and in that case it works perfectly but then I replaced axis with force-wsc due ...
0
votes
3answers
147 views
SOQL with Date filter in WHERE clause [duplicate]
@AuraEnabled
public static List<StaffReport__c> getUserReports(String UserId, Date startDate, Date endDate) {
return [Select Date__c from StaffReport__c where User__c =: UserId AND Date__c &...
0
votes
1answer
60 views
How to provide default DateTime value in UTC time
I am providing a default value to a DateTime field in my apex class.
customobject.DateTime__c = DateTime.parse('01/01/1990 12:00 AM');
I want to set the default value to 01/01/1990 12:00 am UTC ...
0
votes
0answers
31 views
DateTime newInstance doesnt get in user locale
In my code I try to set datetime based on selected location. The Idea is, when the user select locale and then the time, record will be saved with selected datetime value based on selected locale. But ...
2
votes
1answer
126 views
onChange event is not fired for lightning:input type=“datetime” when clear Time field
I have the following component:
Example.cmp
<lightning:input
aura:id="field"
type="datetime"
name="datetimeInput"
label="Set up a date/time"
...
1
vote
0answers
72 views
SAQL Date format conversion
I am pulling in a date field from a secondary (Japan) SFDC org into our native org. The format in the Japan org shows it as just a date (yyyy-MM-dd) but when I look at the date in the data connection ...
2
votes
1answer
30 views
DateTime.parse doesn't take seconds or offset
DateTime.parse() won't take seconds or offsets, at least not in the US. The format from the documention in DateTime.methods() is the only one I can find that works:
Datetime dt = DateTime.parse('10/...
1
vote
1answer
120 views
How to Address Daylight Savings Complications when Converting Date to Date/Time?
Note: I've tagged this question with 'Apex' because there doesn't seem to be any other way to resolve it. I'm able to call on an Apex Action in a flow, but I need help with the code.
Background
My ...
0
votes
1answer
38 views
How to compare datetime field in the format 2019-01-02 04:18:00
I have a Datetime field in Salesforce called Checkin_Date__c. I have got a list of records, then trying to compare the checkin datetime field in all the records, and want to store the recent one. But ...
1
vote
2answers
50 views
What happens if I don't provide Time in Date/Time field
I am creating a Rest API. I have one DateTime field(one of the field for POST request). Wondering what happens if someone calls the API, makes the POST request and fills out just the Date part of the ...
0
votes
1answer
43 views
ISO8601 Z conversion to local date (Pacific) within SQL
I can't figure out how to take this ISO8601 date and convert it to local time (PDT).
I've tried a couple things:
convert(datetime, updated_at_text, yyyy-mm-ddThh:mi:ss.mmmZ) as LastUpdated,
convert(...
1
vote
2answers
412 views
Formatting Datetime.now()
I need to format my Datetime.now() to be accepted for a SOAP request.
I can't seem to find a way to format it online. Can anyone advise? I need it to look like: 2019-05-02T21:20:29.999Z
Currently I ...
7
votes
1answer
90 views
Set collection doesn't always enforce uniqueness with the Date datatype? Does the following example seem correct?
Consider the following unit test:
@istest
public static void datetests2() {
Set<Date> dts = new Set<Date>();
dts.add(DateTime.now().Date());
dts.add(DateTime.now().addHours(1)....
0
votes
1answer
70 views
Business Hours calculation is incorrect/ not consistent for certain dates
My use case is to calculate the deadline to respond on the Case. Rule is to add 10 business days from the complaint received date.
Defined the business hours:
Logic 1
Date initialDate = ...
1
vote
0answers
27 views
Convert time to recipient's local time on Email marketing
I'm building an email invite to join our webinar on Marketing cloud. My recipients are based in different time zones. How can I convert my webinar time to their local time zones?
I'm using BeePro to ...
0
votes
2answers
33 views
I want the result of my query should be without the time and only date will be shown in result [closed]
Select Id, CreatedDate From Opportunity Where DAY_ONLY(CreatedDate)
this the query I used but result is still with time
0
votes
1answer
38 views
Not getting the right time in apex
DateTime.now() return time stamp which is 10 hours more than the current time, I am currently using the Hawaii standard time please find below the snippet now current time is 6:11 am but if I use ...
1
vote
1answer
125 views
Compare DateTime in Apex
I have created 2 dateTime Instances as below to compare DateTime.now() if it is greater than 8 pm and less than 7:59 am then I want to execute some code but it is difficult to compare dateTime as the ...
0
votes
0answers
25 views
ISO 8601 date/time parsing incorrectly from API input
I have a REST API pushing data into a Marketing Cloud data extension and SFMC appears to be transforming it to the system date/time vs the original input from the API.
eg. I have a record with an ...
0
votes
1answer
58 views
DateTime field value in Text formula
I have a DateTime field which shows proper time on UI, I know behind the scene it is GMT format. However I would like to populate same format as it displays on UI in a text field along with some text.
0
votes
1answer
436 views
Convert 24 hours date time to 12 hours date time format
I need to convert and assign 24 hours date time value to custom date time field.
For Example, in my apex code I am getting the date time value as ‘2019-03-12 14:38:00’, I need to convert and assign ...
1
vote
1answer
30 views
Get the Hour from a date time field with the current time zone in a formula field
I create a custom field to display the hour and the minute of a date time field.
The format I need is HH:MM
For now, I get the hour in GMT but it is wrong because I am in France and the time zone ...
1
vote
0answers
20 views
How to get records created between timeframe in a report
I need to create a report of all the records between 7am to 5pm CST/CDT everyday. How can I achieve this?
The solution I tried -
Created a formula field which extracts Hours from created date (...
0
votes
1answer
297 views
SOQL DateTime Greater than Date
For the life of me I cannot figure out how to query tasks greater than a given DateTime. I have a field, inqDateTime, that I need to pull tasks greater than that date. I have tried to convert the ...
0
votes
1answer
37 views
How to Parse date time String to DateTime using Apex
Given this string value:
String dateTimeString = '20/12/18 16:39:51'; // or '31/10/18 09:35:16'
How would I parse it to a DateTime?
I've tried this:
DateTime dt = DateTime.parse(dateTimeString);
...
0
votes
2answers
71 views
Date-time stamp in sends & opens data view in marketing cloud is not in sync with local time
I'm using salesforce marketing cloud for sending emailers. Date time settings in my account are set as per IST (Indian standard time), GMT + 5:30.
Though when I fetch data from "Sends" & "Opens" ...
1
vote
1answer
22 views
Getting the non-converted time of a DateTime
Hi I'm having an issue with getting the non-localized time of a DateTime's time value. Here's some of the execute anonymous I'm having trouble with.
DateTime aDate = DateTime.newInstance(System....
2
votes
1answer
101 views
Adding days to the Date portion of DateTime throws off the Time portion
So I'm having an issue in Apex with the Date's addDays function. It seems that adding more than a certain amount of days throws off the time by one hour. It all seems so arbitrary so I'm wondering ...
2
votes
1answer
85 views
In process builder, how do I write a formula to set a relative day but a specific time?
In this example, let's say a new account is created and we want to have a kickoff lunch with that new account. I'm setting up my logic in process builder using a Start Date Time set to...
...
0
votes
1answer
56 views
Issue with apex:input datetime
I have a page where a patient enters the appointment date for consulting, I m showing a dateTime input fields as
<apex:input type="datetime-local" value="{!appointmentDate1}" styleClass="bRadius ...
1
vote
1answer
116 views
Setting a default TIME value only, on a Date/Time field
We have a Date/Time field on a custom object which lets us choose the date (perfect!), but defaults the time as 12:00:00. We want it to default to 09:00:00.
I tried to go and change the default ...
0
votes
1answer
33 views
Date is Subtracting 1 day after converting to other format
For some reasons, the Date is subtracting one day whenever it is converted to other formats, I don't have any idea why this is happening. I am using .addDays(1) to temporarily solve the issue, but I ...
0
votes
1answer
104 views
System.QueryException: value of filter criterion for field 'CreatedDate' must be of type dateTime
Below my code, I want to pass date value as a parameter but I facing an error as below,
message: System.QueryException: value of filter criterion for field 'CreatedDate' must be of type dateTime and ...
