July 27, 2017 Merfantz Editor Salesforce Developments Tutorial 0 To find whether the record creation Date is Weekday or Weekend it would be simple formula., CASE (MOD ( CreatedDate – DATE (1900, 1, 7), 7), 0, “Weekend”, 6, “Weekend”, “Weekday”,NULL) To find Day of the record creation date use the below, CASE (MOD ( CreatedDate - DATE (1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday”, “Error",NULL) ————————Hope this will help you!——————————- Tags: Field Service ManagementFieldax
CASE (MOD ( CreatedDate - DATE (
1900
,
1
,
7
),
7
),
0
,
"Sunday"
,
1
,
"Monday"
,
2
,
"Tuesday"
,
3
,
"Wednesday"
,
4
,
"Thursday"
,
5
,
"Friday"
,
6
,
"Saturday”, “Error"
,NULL)