-
Saved Search - check if date/time is outside of work hours.
I have tasks that are automatically generated. I want to know however, if this was done outside of work hours. I can check for the day, to see if it's a weekday or weekend. However, how can I check, for example if the time that I get back with a formula is say before 8am and after 3:45pm? CASE WHEN ({createddate},…
-
Create a custom field on a custom form that calculates the difference between two date/time fields
Created two (2) Date/Time custom fields called Time In and Time out on a custom record. These fields are successfully being used to enter time in and time out in the field. I was able to successfully add the difference between these two fields to a Saved Search using a formula: I have been asked to create a custom field…
-
Workflow - Set Field Value - Convert time/date field to date field
Hi, I have a workflow where I'm trying to Set a custom Date field with the value from the Date Created field. If I do the following: It will pull the date created, but use the current year instead of the year the record was created: My guess is this is happening because the field I'm trying to set the value to is a DATE…
-
Is there a way to determine what time zone was used to set a date?
We have a custom date time field. Since we are a global organization, we would like to display a date according to the time zone preference as well as a specific time zone in a saved search. Outputting the plain date field in the saved search takes care of the local time zone display. For the specific time zone, (IST), I…
-
How to Use Set Field Value to Source a Date/Time Non-store Field?
Hi all I'm trying to do something that I expected to be pretty simple. I have a non-stored firld on record which is populated by a search for latest (max) of a date/time field. This give me a non-stored DD/MM/YYYY HH:MM:SS AM fomatted value. Using a scheduled (server-side) workflow, I just want to pass that value to…