+ Start a Discussion
Sugar GozomSugar Gozom 

Displaying the Day of the Week From a Date (1900,1,7)

Hi everyone,

I'm new to coding here, I would just like to know why do we need to subtract this value "Date(1900, 1, 7)" to a certain date to get the day of the week? I don't quite understand what's with this date? Eg "MOD( TODAY() - DATE( 1900, 1, 7 ), 7 )".

Thanks for the help.
Manish BhatiManish Bhati
It is just a date whose day is known as Sunday. So, they use it to find day of the week and other places where day is to be resulted.

The reason is from the Salesforce Documentation
http://resources.docs.salesforce.com/202/10/en-us/sfdc/pdf/formula_date_time_tipsheet.pdf

To find the day of the week from a Date value, use a known Sunday (e.g. January 7, 1900) and subtract it from the date (e.g. TODAY()) to get the difference in days. The MOD() function finds the remainder of this result when divided by 7 to give the numerical value of the day of the week between 0 (Sunday) and 6 (Saturday).

Mark it as answer if it clear your doubts.
Vasani ParthVasani Parth
+1. Let us take couple of examples to illustrate how this works. January 1, 2006 was a Sunday. Let us start with a date in 2006, say Feb 1, 2006. So Date__c is set to “2006-02-01”. Now (Date__c -DATEVALUE(“2006-01-01″ ) returns number of days after Jan 1, 2006. In this example this gets set to 31.

Now the next step is to convert the elapsed days into elapsed weeks. This is done by dividing by 7. In this example we get the number 4.43. Now we take the Floor of this number to get 4. The last step is to take a modulo with 52. This is to get the week number for current year. The MOD returns 4, since the number is less than 52. Now we have the week number, where the first week is 0. To get the week number, where the first week number is 1, we add 1 to get the final week number is 5.

Please mark this as the best answer if this helps
chathura ranasinghe 10chathura ranasinghe 10
Hi Sugar

Here are some links to refer : 

https://developer.salesforce.com/docs/atlas.en-us.formula_date_time_tipsheet.meta/formula_date_time_tipsheet/formula_examples_dates.htm#!
https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/date_formulas

Thanks
Chathura
peclon joepeclon joe
Improve the security of a MariaDB installation. ... mysql_secure_installation is a shell script available on Unix systems, and ... You can remove root accounts that are accessible from outside the local host. ... You can find here setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. 
Baya AdamBaya Adam
My articles is a family member  of guest posting websites which has a large community of content creators and writers.You are warmly welcome to signup and publish a guest post with a dofollow backlink no matter in which niche you have a business. Follow your favorite writers, create groups, forums, chat, and much much more!
 
Jhon RobinsonJhon Robinson

Everyone wants to learn coding like a pro developer that way u need to eat some almonds if want to know about almonds in hindi called badam ka ped (https://newinhindi.in/jankari/badam-ka-ped-kaise-hota-hai/) this is for u i found that on internet ...

want to know everythings in hindi ( https://newinhindi.in/  )
Bronson FlinnBronson Flinn
i was looking for this for (https://www.apextilers.com/) so long great pc of work man keep it up
Shom klains303Shom klains303
In just two years from the time the first time it was released in the year 2019, Disney Plus has gained popularity with all age groups as one of the top streaming services available online around the globe. Anyone who used to watch Disney’s high-quality films and shows can revisit those memories and experience a sense of nostalgia.

Also Read:https://onlinesurvey.onl/disneyplus-com-login-begin/