Hello

I have a formula on a custom object to show the day of the week:

CASE(MOD( Datevalue(CKSW_BASE__Start__c) - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")

For records post clock change on 29 March 2021, the day of the week is showing incorrectly if the start time of the record is 00:00.

Example:

28/03/2021 18:30  29/03/2021 06:30  Sunday
28/03/2021 21:00  29/03/2021 07:00  Sunday
28/03/2021 22:00  29/03/2021 08:00  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday

Can anyone provide any help with this please?

Hoping someone can help with this issue!
In Lightning, we have a custom object and when a user creates a new record within that object then refreshes their browser they are taken back to the landing page of the object rather the the record that they have just created.

Hello
I'm trying to get the Week Number into a new custom field.  I need to calculate the week number from a standard Field Service Lightning field named "SchedStartTime".  The data type for this field is Date/Time.  I created a custom formula field to capture only the date from the SchedStartTime field named "Scheduled Start Date" with the formula: DATEVALUE(SchedStartTime ).  I then created another custom field named "Week Number" with the formula: MOD (FLOOR (( Scheduled_Start_Date__c - DATE(2019,12,30) + (1/24) ) / 7),53)+1.  However, there are errors when the Scheduled Start is midnight (00:00), the Week Number should update to the next week number but this isn't happening until the Scheduled Start is 01:00.  See example below:

Scheduled Start     Week Number
14/06/2020 23:00          24
14/06/2020 23:30          24
15/06/2020 00:00          24
15/06/2020 00:30          24
15/06/2020 01:00          25

Can anyone provide help please?  Note that our Org has the Default Time Zone(GMT+01:00) British Summer Time (Europe/London).

Hello. I have tried to source more information on this task but have been unsuccessful.  In addition, the information I have found relates to the old version of Flow.  Please note my experience level of Flows is beginner!

I have created a Flow which is triggered via a Process Builder for when a new User record is created, a specific Permission Set is allocated to that User.  However I want to extend that Flow so that if a new User record is created and they have a custom checkbox field checked, then 3 specific Permission Sets are added to that User record.  Once this is done, a new custom resource record should be automatically created and populated with some information from the User record.  Is this possible and if so, please could someone provide guidance?

Many thanks in advance.

Hello

I have a formula on a custom object to show the day of the week:

CASE(MOD( Datevalue(CKSW_BASE__Start__c) - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")

For records post clock change on 29 March 2021, the day of the week is showing incorrectly if the start time of the record is 00:00.

Example:

28/03/2021 18:30  29/03/2021 06:30  Sunday
28/03/2021 21:00  29/03/2021 07:00  Sunday
28/03/2021 22:00  29/03/2021 08:00  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday
29/03/2021 00:00  29/03/2021 23:59  Sunday

Can anyone provide any help with this please?

Hoping someone can help with this issue!
In Lightning, we have a custom object and when a user creates a new record within that object then refreshes their browser they are taken back to the landing page of the object rather the the record that they have just created.

Hello
I'm trying to get the Week Number into a new custom field.  I need to calculate the week number from a standard Field Service Lightning field named "SchedStartTime".  The data type for this field is Date/Time.  I created a custom formula field to capture only the date from the SchedStartTime field named "Scheduled Start Date" with the formula: DATEVALUE(SchedStartTime ).  I then created another custom field named "Week Number" with the formula: MOD (FLOOR (( Scheduled_Start_Date__c - DATE(2019,12,30) + (1/24) ) / 7),53)+1.  However, there are errors when the Scheduled Start is midnight (00:00), the Week Number should update to the next week number but this isn't happening until the Scheduled Start is 01:00.  See example below:

Scheduled Start     Week Number
14/06/2020 23:00          24
14/06/2020 23:30          24
15/06/2020 00:00          24
15/06/2020 00:30          24
15/06/2020 01:00          25

Can anyone provide help please?  Note that our Org has the Default Time Zone(GMT+01:00) British Summer Time (Europe/London).

I am a bit of a beginner at formulas, so hopefully one of you will think this is easy, and be able to help. :-)

 

Customer requirement:

 

Create a formula field that displays the Week Number (as Week 1, Week 2, etc), based on the Date entered on a particular record (same object).

 

Ex: 01/01/09 - 01/04/09 would return a value of "Week 1"  

01/05/09 - 01/11/09 = Week 2

01/12/09 - 01/18/09 = Week 3

 

and so on.....

 

Is using the CASE function the way to go, and if so, what's the shortest way to create this formula?

 

Thank you in advance!

S