Questions tagged [dayofmonth]

74 questions
6
votes
3 answers

Python Pandas - Get the rows of first and last day of particular months

My data set df looks as follows: Date Value ... 2012-07-31 61.9443 2012-07-30 62.1551 2012-07-27 62.3328 ... ... 2011-10-04 48.3923 2011-10-03 48.5939 2011-09-30 50.0327 2011-09-29 51.8350 2011-09-28 …
Ferit
  • 558
  • 1
  • 5
  • 19
5
votes
1 answer

Get last day of the month from a ZonedDateTime object

I have previously been able to do this with Joda DateTime objects but i'm unsure how i can get the last day of a given month for a ZonedDateTime instance with a timezone applied. e.g A leap year February return 29 April returns 30. December returns…
MisterIbbs
  • 247
  • 1
  • 7
  • 20
5
votes
1 answer

Java date format for 00 days/months

I have a date as String, but sometimes it doesn't have valid day or month (the values are zeros, 00). Example: String value = "03082017"; Then I do: String day = value.substring(0,2); String month = value.substring(2,4); String year =…
Patrik
  • 63
  • 7
3
votes
3 answers

Count date observations in a month

I have a dataframe containing daily prices of a stock exchange with corresponding dates for several years. These dates are tradingdates and is thus excluded weekends and holidays. Ex: df$date <- c(as.Date("2017-03-30", "2017-03-31", "2017-04-03",…
rookie
  • 57
  • 3
3
votes
2 answers

Angular 4 Date-Picker - How to restrict Future and Past Days

I want to restrict the future and past days using Angular 4 Date-Picker.I just want to enable Current Date[today] only.How can i solve this. Can anyone have idea...??? This is my template:
D.Sridhar
  • 139
  • 1
  • 4
  • 11
2
votes
1 answer

flutter DateTime shows that October got 32 days

I've got a problem with DateTime and I don't know what's the matter. I got a calendar app. When I switch the month forward to October of the current year (or the October of the next year, same issue) the October shows a quantity of 32 days. The…
Pauer Auer
  • 101
  • 10
2
votes
1 answer

Understanding function endpoints

I have a time series of returns. In the first column I have all my dates. With this function (searching for hours) I finally managed to get the first value of every month. The problem was, that not always day 1 is the first value. Sometimes it is…
J.Pop
  • 35
  • 5
2
votes
1 answer

crontab (cronie), run certain days of the month

I want to make a crontab entry which will run on every weekday except the 1st, 2nd, and 3rd of each month. Here's what I have: 45 8,12,16 4-31 * 1-5 my_program I thought that this had the following meaning: minutes: 45 past the hour hours:…
Ed Avis
  • 1,350
  • 17
  • 36
1
vote
1 answer

SQL date comparison using case; for month to date reporting

The goal is to provide month to date (MTD) reporting, based on a list MTD dates created by an SQL query. however when we're on the 1st day of the month my queries don't work (the list of dates aren't relevant) the query I use to create a month to…
Lwazi Mace
  • 15
  • 4
1
vote
0 answers

python dataframe rolling on month-end dates: rolling average of the lowest 1% values

For each month-end date and each "PERMNO" (company identifier), I'd like to compute the rolling average of the lowest 1% values in the past 252 days from a dataframe column named "RET" To compute it, I did: def get_es(x): return…
1
vote
2 answers

R: Only keeping the first observation of the month in dataset

I have the following kind of dataframe, with thousands of columns and rows. First column contains dates, and the following columns contain asset returns indexes corresponding to that…
datgoaltho
  • 71
  • 4
1
vote
0 answers

Django how to get days count of month in specific year

class MainYear(models.Model): year = models.CharField(max_length=4,blank=True,null=True,default=get_current_year()) def __str__(self): return str(self.year) @property def get_all_month(self): return…
1
vote
1 answer

JCalendar sets to March 30 when February is chosen

Code consists of just month and year can be chosen in jcalendar, by default the day is 30 and 28 for February, the issue comes when I choose February, automatically jcalendar sets to March 30; this is the code; it is in PropertyChange event of…
1
vote
3 answers

How to display day names and number from current date in android

Hi I am implementing a feature called calendar. Now From current month name and current year from this how to display day names and day number . Code: cal.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); Date startDate = cal.getTime(); …
jyothi sri
  • 51
  • 6
1
vote
1 answer

Date is not working even when date column is set to index

I have a multiple dataframe dictionary where the index is set to 'Date' but am having a trouble to capture the specific day of a search. Dictionary created as per link: Call a report from a dictionary of dataframes Then I tried to add the following…
1
2 3 4 5