I understand that i can get a number that represent the day number in a julian calendar. JDN http://en.wikipedia.org/wiki/Julian_day. For example for a date 10/10/10 i can get a number 2455479.5. My question is how to get a weeks and moths number, that means a continuous number of months or weeks like the JDN. This si very useful in reports and BI dashboards. I am using js but it can be useful for other languages.
Calculate week number in a period of years like JDN in js
300 Views Asked by shau At
1
There are 1 best solutions below
Related Questions in JAVASCRIPT
- Using Puppeteer to scrape a public API only when the data changes
- inline SVG text (js)
- An array of images and a for loop display the buttons. How to assign each button to open its own block by name?
- Storing the preferred font-size in localStorage
- Simple movie API request not showing up in the console log
- Authenticate Flask rest API
- Deploying sveltekit app with gunjs on vercel throws cannot find module './lib/text-encoding'
- How to request administrator rights?
- mp4 embedded videos within github pages website not loading
- Scrimba tutorial was working, suddenly stopped even trying the default
- In Datatables, start value resets to 0, when column sorting
- How do I link two models in mongoose?
- parameter values only being sent to certain columns in google sheet?
- Run main several times of wasm in browser
- Variable inside a Variable, not updating
Related Questions in DATE
- Using JQuery Date Slider
- Get Type Error when using .countDocuments with mongoDB
- Gsheet - Automatically send an email using a date & time in a Cell
- Market share growth versus last month, last year
- Convert date string into a number in Python
- Date formatting "yyyy-MM-dd hh:mm:ss +0000" to "dd MMM" in swift
- How does Big Query differentiate between a day and month when we upload any CSV or text file?
- Event_date reference in CTE
- Laravel Nova 4 format date in BelongsTo field
- how to count days elpased between each interval using mySQL?
- MariaDB incorrect dates
- Date issue - how do I parse date in this SQL
- Countdown to varying payday in Javascript
- Can I have a static ISO8601DateFormatter with specific formatOptions in Swift?
- Date Format mdy vs dmy
Related Questions in JULIAN-DATE
- Display 5 digit Julian Date in IFRAME
- Why does oracle sql/dapper not recognize these numbers?
- Julian date of timezone-aware timestamp?
- Selected date in a datetime-local input is wrong for date prior to 15 October 1582
- How can I convert Julian dates to fit my data ? (eg. January 2nd would be "2" but I need it to be 365 +2 = 367)
- Wordpress: Filling out a custom field automatically on post creation
- covert date to Julian date in bigquery
- Python Pandas Dataframe convert julian day column to date column
- Coverting JDE Julian Date to Calendar Date within a select statement
- Easy way to convert Julian calendar to standard with Python xarray?
- Loop through consecutive time periods
- How to convert date to Julian date in Dart
- Calculate Julian Day based on a different reference day
- Converting 7 digit dates to normal calendar dates in Databricks python
- How to transform YYYYDDD to DD-MM-YYYY
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The Julian Day provides a universally accepted day count from a specific point in time -- but there is no universally accepted week or month count that is comparable with the Julian Day count.
The closest thing to an official week count is the ISO 8601 standard, but it recycles every year, so it's quite different from what you're suggesting.
You could certainly extrapolate the week count from the Julian Day, simply dividing by 7. And you could come up with a month count with some basic math. I haven't tested this, but off the top of my head, I think it would be
((current year - -4713) * 12) + 2 + number of month in this year). (The "+ 2" is to adjust for the fact that the Julian Day count started in November, so we're adding 1 for November and 1 for December of that year. This also uses astronomical calculation [which has a Year 0] rather than historical calculation [which jumps from 1 BCE to 1 CE]; if you're using the historical calculation, adjust accordingly.)In short, though, if you're looking to implement something that already exists and that will be recognizable to others, I think you'll find there's nothing out there.