Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

How to run a report to identify out of hours cases

I am trying to run a report detailing the cases which are received out of hours and have a chart associated. I found the below on a site IF( LEN( CREATED_DATE ) = 1, '0' + CREATED_DATE + ':...
Julia Matchett's user avatar
0 votes
1 answer
32 views

How do we change default drop down values in Date Time field for Time drop down?

I have a Date Time field, in Time Drop down the values display as 12.00 am, 12.15 am, 12.30 am and so on, but i need only to show interval with 1 hr, like 12 am, 1 am, 2 am and so on. Please help on ...
Harikrishna Parvatam's user avatar
0 votes
1 answer
103 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
455 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
531 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
34 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
99 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
907 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
  • 502
1 vote
0 answers
564 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
1 answer
918 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
461 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
354 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
502 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
687 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
241 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
818 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
1k 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
2k 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
  • 502
3 votes
1 answer
4k 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
2k 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
  • 467
0 votes
1 answer
73 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
  • 502
0 votes
1 answer
1k 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
632 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
2k 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
670 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
61 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
1k 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
227 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
314 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
288 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
995 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
42 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
6k 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
1k 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
  • 155
0 votes
1 answer
247 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
279 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
75 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
2k 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
538 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
  • 441
2 votes
0 answers
917 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
761 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,081
0 votes
2 answers
2k 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
  • 119
1 vote
0 answers
631 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
  • 183
0 votes
0 answers
352 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
82 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 (...
P P's user avatar
  • 107
1 vote
0 answers
235 views

Is it possible to calculate the difference between 2 Time Fields with Formula?

I am trying to calculate the difference between 2 Time-fields with a FORMULA . (So no DateTime) I know it is possible in Apex, but I am wondering if it is possible in a Formula as well. I tried a lot ...
nesnaj713's user avatar
  • 248