Questions tagged [time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-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 ...
Josh Bridgman's user avatar
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 ...
SF Learner's user avatar
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&...
arnaud's user avatar
  • 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, ...
Miguel Bohrz's user avatar
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&...
Ekemo's user avatar
  • 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?
Aditya Paranjape's user avatar
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=...
Daniel Velesevich's user avatar
-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 ...
jojopogi's user avatar
  • 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). ...
Explorer013's user avatar
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 ...
MnZ's user avatar
  • 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 ...
Sander de Jong's user avatar
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? ...
vanessa's user avatar
  • 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> ...
joe jung's user avatar
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, ...
alechko's user avatar
  • 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 ...
Niteen's user avatar
  • 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)?
Stasia's user avatar
  • 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: ...
Emmanuel BRUNO's user avatar
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 ...
JeffMTI's user avatar
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 ...
jojopogi's user avatar
  • 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 "...
Felix van Hove's user avatar
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,...
Dave C's user avatar
  • 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 ...
jojopogi's user avatar
  • 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('...
EDD rico's user avatar
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 ...
Slava's user avatar
  • 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. ...
Jays619's user avatar
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 ...
Tejas's user avatar
  • 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 ...
Nick Yang's user avatar
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 ...
indrasen neelam's user avatar
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 ...
HoldenIsCoding's user avatar
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
Akash's user avatar
  • 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}...
Narsari's user avatar
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....
SFDC 44's user avatar
  • 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 ...
Brian Kessler's user avatar
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 ...
Brian Kessler's user avatar
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 ...
Aditya Sehgal's user avatar
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 ...
Sindhuja's user avatar
  • 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'...
Collen's user avatar
  • 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: &...
Krishnamurthy's user avatar
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}...
Tomas Garcia Etchegaray's user avatar
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 ...
Ezekiel Hammond's user avatar
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 ...
Shahil Khan's user avatar
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....
Mar Andrés López's user avatar
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().
John1019's user avatar
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 ...
user28452's user avatar
  • 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 = ...
Héctor Cervera Panella's user avatar
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 (...
S.B.'s user avatar
  • 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?
s3002068's user avatar
  • 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 ...
JURY's user avatar
  • 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 ...
Viktor's user avatar
  • 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 (...
M P's user avatar
  • 107