+ Start a Discussion
Peter JefferyPeter Jeffery 

Checkbox ticked if record was created previous working day (Mon - Fri)

Hi, I'm trying to get a checkbox ticked where the created date is yesterday except for on a Monday where it would need to be the previous Friday, any help appreciated.
 

Regards,

Pete

Best Answer chosen by Peter Jeffery
Ahmad J. KoubeissyAhmad J. Koubeissy
You can created two formula fields.

The first one:
Today Name (Type = Text).: to get the name of the current day, this one wont be visible on the layout
CASE( 
MOD( TODAY() - DATE( 1900, 1, 7 ), 7 ), 
0, "Sunday", 
1, "Monday", 
2, "Tuesday", 
3, "Wednesday", 
4, "Thursday", 
5, "Friday", 
"Saturday" 
)
The second one:
Created Yesterday (Type=CheckBox): it checks if the current date if monday and if the created date is Friday, so its true, else it will check it created date is yesterday .
IF(Today_Name__c='Monday' && DATEVALUE(CreatedDate) = Today()- 3,true,IF(DATEVALUE(CreatedDate) = Today()- 1,true,false))

If this solves your problem, kindly set as best answer. thanks
 

All Answers

Ahmad J. KoubeissyAhmad J. Koubeissy
You can created two formula fields.

The first one:
Today Name (Type = Text).: to get the name of the current day, this one wont be visible on the layout
CASE( 
MOD( TODAY() - DATE( 1900, 1, 7 ), 7 ), 
0, "Sunday", 
1, "Monday", 
2, "Tuesday", 
3, "Wednesday", 
4, "Thursday", 
5, "Friday", 
"Saturday" 
)
The second one:
Created Yesterday (Type=CheckBox): it checks if the current date if monday and if the created date is Friday, so its true, else it will check it created date is yesterday .
IF(Today_Name__c='Monday' && DATEVALUE(CreatedDate) = Today()- 3,true,IF(DATEVALUE(CreatedDate) = Today()- 1,true,false))

If this solves your problem, kindly set as best answer. thanks
 
This was selected as the best answer
Danny Sk 6Danny Sk 6
I received great help from this post. Thanks. https://mycfavisit.me/  (https://mycfavisit.me/https://tellgamestop.vip/
Kevin SampleKevin Sample
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content.

Thanks,
Essays Chief (https://essayschief.com)
yamini sharma 31yamini sharma 31
alina chopraalina chopra
Calming you emotionally, our escorts always provide the best support that helps you in the relaxing. With our independent Delhi escorts (http://www.alinachopra.com/delhi-escorts-whatsapp-photo.html), you can unveil the dirtiest secret of yours and can trust these girls for not disclosing them. 
 
Olivia FrancisOlivia Francis
I like to follow successful results in sports. Such articles and achievements motivate me a lot. I have time for such a hobby thanks to the best professionals https://essaysbank.com/write-a-case-study
more malikmore malik
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content.
https://startupindiamagazine (https://startupindiamagazine.com)
more malikmore malik
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content.
(https://qualitytechtalk.com/)
Sylvia WarrenSylvia Warren
There is nothing more interesting and exciting that freshmen traditions (https://collegehomeworktips.com/college-freshmen-traditions/) students follow. The most impressive fact here is that every single college has its authentic customs. 
Jennifier radyJennifier rady
You can easily pay your traffic tickets (https://njmcdirects.online/) with the help of trusted sources. As i really liked the content that showed in the section here . Thanks for providing such great stuffs. 
Uladzimir MiachovskiyUladzimir Miachovskiy
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content. https://hackpro.fun
Shweta Gupta 66Shweta Gupta 66
The post is interesting. It says that Checkbox ticked if the record was created previous working day. I am Shweta. I am a woman with a slim body and an amazing figure. I am one of the most beautiful Mumbai Escorts. I am one of a professional call girl and thus with me, you will get all the excitement and satisfaction you have been craving for. When it comes to pleasing my customers, my experience and my knowledge have taught me a lot. I can make your wildest dreams come true with my sizzling moves and poses.
Charles BronCharles Bron
Interesting Post!!! Checkbox ticked - once the record is created previous working day. Pay tickets easily https://njmcdirect.online/
matt donavanmatt donavan
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content. you can pay tickets easily by njmcdirect (https://districtchronicles.com/njmcdirect-nj-traffic-tickets-payment-guide-www-njmcdirect-com/) or njmcdirect.com (https://districtchronicles.com/njmcdirect-nj-traffic-tickets-payment-guide-www-njmcdirect-com/)
kav efkav ef
Today's News Headlines, Breaking News & Latest News from India and World, News from Politics, Movies, Tv Shows, Sports, Business, Arts and Entertainment. 
Website: One News Live (https://onenewslive.in/)
Baya AdamBaya Adam
Information Transformation Services is endowing the clients with a stunning and impressive visual experience crafted by 3D Modeling Services (https://it-s.com/our-services/2d-3d-modeling/3d-product-models/). We are completely forted to offers our customers with a range of appealing 3D designs that are carefully crafted to meet with all type of requirements. 
entahma buddyentahma buddy
Whenever you have actually violated either traffic rules or parking guidelines in New Jersey, you will receive a traffic ticket for the same. Be it a car parking violation ticket or a traffic violation ticket, you require this since it stands as evidence. Open NJMCDirect Official website - https://njdirectconnection.com/ in order pay the traffic tickets conveniently.
Raj Singh 93Raj Singh 93
The post is interesting. It says that Checkbox ticked if the record was created previous working day. You can know about it in detail if you go through the post. You can resolve all your concerns if you go through the content. Ownarmy (https://ownarmy.org/)