Questions tagged [time]
The time tag has no usage guidance.
108
questions
-2
votes
0
answers
51
views
Checkbox Formula Field that Evaluates if Time is between Two Values
I've created a field called Current_Date_Time__c that displays the current date/time in the following format: 7/09/2023 8:40 AM.
I'm trying to create a new checkbox formula field that evaluates as ...
0
votes
1
answer
65
views
I have a req to show different date time values based on different condition. One to display time in ISO, then in full date along with time & zone
I want to display time in 3 different formats, along side follow the translation strategy as well. That is if user selects to translate the page, user should be able to see the date in his/her local ...
- 54
0
votes
0
answers
91
views
JDK Locale Format Retirement
I received an email from Salesforce informing that the JDK local format will be retired JDK Locale Format Retirement with the Spring ’24 release.
https://help.salesforce.com/s/articleViewid=000380618&...
- 104
0
votes
0
answers
215
views
Passing lightning-input time value from LWC to APEX taking timezone into acount
I'm having trouble passing a time (not datetime, not date) from custom LWC to APEX and saving it taking the user time zone into account. Before giving the details, I'd like to say that I checked here, ...
0
votes
3
answers
142
views
Time Value Formula, IF statement check box
I've been trying to work out some sort of syntax for a simple custom checkbox to be ticked when it's time based.
So far i've created this:
IF( TIMEVALUE(" > 16:00:00.125 < 16:05:00.125&...
- 3
0
votes
1
answer
31
views
Journey Builder - If I change the time of my automation which sends data in a journey, will the send time of the journey change?
If I change the time of my automation which sends data in a journey, will the send time of the journey change?
1
vote
1
answer
70
views
How to replace time part of DATETIME input by value from TIME input
I've tried to find an algorithm (Salesforce, aura) but without success. Probably, you have any ideas!
I have:
attribute
<aura:attribute name="bulkApply" type="Map" default=...
-1
votes
1
answer
131
views
CreatedDate = LAST_N_MONTHS:3 vs CreatedDate >= LAST_N_MONTHS:3
This might be a silly question... but I'm trying to get the records created within the last 3 months. I have a custom object and I have the following two queries below. I see that the results are very ...
- 484
1
vote
0
answers
340
views
Calculate Salesforce Case response time
I'm new with salesforce formula and I have this requirement to compute the business hours with mins. in salesforce case.
what i did is that i set-up one field in case objects (data type = formula). ...
- 11
0
votes
0
answers
36
views
Dynamic chart titles for time filter
I have a time filter for different quarters/months/years. When I select the a value in the time filter dropdown, how do I update the chart title with similar value?
Currently I have bucketed the ...
- 3,152
0
votes
1
answer
451
views
Problem with formula with TIMEVALUE()
I want to have a field that can be used as the basis for 5-minute buckets. So, for example 9:45, 9:46 ... 9:49 should all result in 9:45.
Computations with time values are a bit awkward, at least for ...
- 3,848
0
votes
1
answer
326
views
Set Time value with a default time
I created a time field with a default time value below. If I go to the record and I create/edit/view the record, the Time field does not show the default value. Is this default value format correct?
...
- 11
2
votes
2
answers
258
views
APEX - Loop and SOQL - Performance Question (Time and Space Complexity)
Hello Salesforce Devs!
I'm just curious to know which one of the below has better performance when looking up child records.
For example, finding number of cases on an account:
#1: List<Account> ...
- 94
0
votes
0
answers
396
views
Manipulating lightning-input-field time field value
I'm trying to figure out what's the best way to manipulate value for time field from javascript.
When loading a record with LDS the value of the time field is an integer represented in milliseconds, ...
- 53
0
votes
1
answer
508
views
time depended workflow is made inactive, is that it will still send the email
I have implemented the time depended workflow to send email after 10 days. Now 4 days are left to trigger the work flow to send the mail. But new i dont have a need to send the email hence i have ...
- 5
0
votes
0
answers
188
views
How to remove seconds and milliseconds from mobile view of lightning-input time type
Is there a way to remove or hide seconds and milliseconds from lightning-input time type (on mobile android device)?
- 15
1
vote
1
answer
582
views
Test if a Time field value changed in flow decision... causing exception
I ran into an issue with a flow who stopped with an error, giving no more details than :
UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this
ErrorId if you contact support: ...
- 1,036
0
votes
0
answers
870
views
LWC lightning-datatable ignores time-zone for Time (not Datetime) data
Unlike Date and Datetime fields, Time fields are displayed and stored in UTC (there is no user locale adjustment. The problem is that the LWC lightning-datatable ignores the time-zone typeattribute ...
- 1
0
votes
1
answer
1k
views
TimeZone Conversion
We have a simple intake form with the following attributes. So you can think of the object records would be as follows:
ID
Military Time
Time Zone
Add Days (from today's date)
1
0700
America/Chicago
...
- 484
3
votes
1
answer
3k
views
Time-to-Text conversion in Flows
I use the "Get Records" element to retrieve an object and select "Choose fields and let Salesforce do the rest" to save a field of type Time on this record. (I've tried "...
- 2,107
4
votes
2
answers
1k
views
How do I use a TIME literal in a SOQL Query?
I am building a dynamic SOQL query that may have a TIME field in the where clause:
select Id,Name,Customer__c,Load__c,Actual_Arrival_Date_D__c,Actual_Arrival_Time_D__c,Actual_Departure_Date_L__c,...
- 427
0
votes
1
answer
68
views
Aura Component get time from Server as opposed to JavaScript/Client Side/Browser Time?
We have an intake form built using Aura Components and its a simple form. The submit button on the aura component is enabled or disabled depending on what time it is. Basically, they are not allowed ...
- 484
0
votes
1
answer
668
views
Why do my apex code uses other time zone?
I'm running this code to get a DateTime and change the time of it to a preset one
DateTime dt = Datetime.newInstanceGMT(2021, 11, 8, 12, 0, 0);
Time t = Time.newInstance(8, 0, 0, 0);
System.debug('...
- 1
2
votes
1
answer
479
views
Your organization has reached its hourly limit for processing workflow time triggers
There are a lot of similar question, but I'm trying to research why I get this message.
I was looking into scheduled jobs and time based workflow. I am aware of the limits. Since I didn't find ...
- 29
-1
votes
1
answer
1k
views
How to compare two different times in formula
So we receive a check-out time which is the date/time field and I want to compare that time to see if it is greater than 12 PM. This will help decide if I need to charge a full day or half-day.
...
- 1
0
votes
1
answer
542
views
Pass time variable from Javascript to Apex
Im trying to send time variable from LWC javascript To apex but not able to do that because of the format.
what is the correct format in which I can send the time variable.
Tried sending in the ...
- 57
0
votes
0
answers
52
views
I cannot receive Salesforce Alert in Slack Channel at specific time
I have completed the integration between Salesforce and Slack. But I only can receive alerts between 12AM - 12PM in CST(Chinese Standard Time) at weekdays, or all days at weekends. Is there anyone ...
0
votes
2
answers
808
views
DateTime value difference in UI and Soql query
The external System updates the date time field as 2021-03-15T09:00:00.000+0000. When I query the SOQL is also returning the same value. But when EST time zone user logins, the record suppose to show ...
- 103
1
vote
1
answer
1k
views
lightning:input type="time" displays millisecond value when editing object
I am building a lightning component to create/edit custom objects. I've been able to do this with force:inputFields in the past but unfortunately ran into a component error that the new recommended ...
0
votes
1
answer
217
views
difference of two date time field in days and hours
How can I show the difference of two date time fields in days and hours. I am trying to do this in a formula field or process builder.
Example: 16/10/2021 11:00am - 15/10/2021 10:00am = 1 day 1 hour
- 361
0
votes
0
answers
282
views
Time format is changing from(hh:mm:ss) to number
I have created a custom field of time datatype. I am using this custom field in my lightning component.
It is displayed in number.
<lightning:input type="Time" value="{!d.Sign_Out__c}...
- 3
0
votes
1
answer
217
views
Time Difference in minutes on 2 'Time' Data type
I have 2-time fields (Start time and End Time). I need to calculate the difference in minutes. I have tried with below code, but does not work.
Double var = Math.Floor((Double.valueOf(mem.End__c....
- 664
1
vote
2
answers
847
views
In Apex, how can I format Datetime for Europe/Berlin without assuming the input value is GMT?
I currently have the following function:
public String formatForGermany(Datetime targetTime) {
return this.format(targetTime, 'Europe/Berlin');
}
private String format(Datetime targetTime, String ...
- 4,498
2
votes
1
answer
40
views
What is the best way to correctly create a string with a time queried from SOQL which needs to be displayed to Germans?
We have a custom Datetime field on a custom object, Appointment__r.Start_Date__c.
At 6pm, the day before the appointment, we must send every customer with an appointment an SMS which reminds them of ...
- 4,498
2
votes
1
answer
5k
views
Salesforce displaying Time custom field in GMT instead of User's timezone
We are facing an issue with BST and GMT time zone.
We have a community portal and the org timezone and all the Users timezone are set as BST.
Part of our functionality is to book an event and we ...
- 151
0
votes
0
answers
887
views
Deploying lightning web component from VScode to sandbox takes more time
I am trying to deploy lightning web component from VScode to the sandbox using the command SFDX:Deploy Source to Org. It was working fine previously but for the past 2 days, deploying is taking more ...
- 133
0
votes
1
answer
212
views
How to format my Salesforce time field for input in visualforce?
I have a time field (new time field format) called Time_In_1__c in a visualforce page. When I enter a value such as "3:00 pm" and hit save, Salesforce displays the value as 15:00:00:000. I'...
- 13
0
votes
1
answer
238
views
How to use time field as an input field in VF Page?
In Salesforce record, the time field shows as a picklist but when I add the same time field to Visualforce page in a form, it only displays as a text field. Am I missing anything here?
Visualforce:
&...
- 311
0
votes
0
answers
71
views
Why time Aura input doesnt display values as expected?
Im using lightning inputs for web compononent and for aura lightning
LWC:
<lightning-input data-formfield="Open1" type="time" variant="label-hidden" value={mondayOpenTime} disabled={mondayOpen}...
0
votes
0
answers
31
views
Error pushing Time from WebForm to SalesForce (Using JSForce as connector and direct REST to Push) [duplicate]
I am building a NodeJS WebApp, that serves up a form, User fills it out, submits it, and then pushes the data from the form to SalesForce.
The App uses JSForce for Authentication, and then it uses a ...
0
votes
1
answer
1k
views
How to trim out "Date" from Date/Time field in Salesforce?
I have a Date/Time field (call it Field A) that gets populated by an external system, i'd like to create another field that trims/extracts the Time value from Field A. I want to do this to use a ...
2
votes
2
answers
1k
views
CreatedDate of new record (Time)
My Org is set to GMT+1 which is my timezone. (Stated in the Company Information).
I have created a record at 11:30 am but when I retrieve the CreatedDate field it says that it was created at 10:30 am....
- 157
1
vote
1
answer
2k
views
Process builder conditions when custom date/time is NOW()
Should be simple but I'm getting stuck on the formula
Building a workflow in process builder and trying to trigger an action when custom object's custom date/time field is NOW().
- 13
0
votes
0
answers
437
views
Time calculation in apex
My requirement is to assign records if the lastmodifiedDate of the record falls within the employee availability. For example let's say on Sunday employee available between 8.00 AM to 5.00 PM and if ...
- 431
2
votes
0
answers
714
views
Add 30 minutes to a Time field using formula
I'm trying to set a formula time field as the result of adding 30 minutes to a time field that returns TRUE in the following comparison.:
Time formula field is:
TimeEndWorkingHoursControl__c = ...
3
votes
1
answer
600
views
How to get time left on OrgPartition from Platform Cache?
Is it possible to get the time left from Platform Cache for a particular partition?
You initiate by:
Cache.OrgPartition orgPart = Cache.Org.getPartition('local.myStore');
You put the value by (...
- 2,039
0
votes
2
answers
1k
views
Format AM/PM DateTime to 24 hour time
I have a data
9/14/2019 4:37:57 PM
I want to format this to: 20190914T163757
How do I format it so that if it includesPM to 24hour using ampscript?
- 109
1
vote
0
answers
603
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 ...
- 173
0
votes
0
answers
329
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 ...
- 360
1
vote
0
answers
75
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 (...
- 107