Stack Overflow
Stack Overflow

Questions tagged [dayofmonth]

74 questions
0
votes
1 answer

Create monthly trigger for Scheduled Task in Powershell (With additional criteria)

I'm currently working on a script that when run, creates some Scheduled tasks that makes the host machine do several things and then restart within a specified time span. This script needs to be run on multiple domain controllers, and therefor i…
Thestorum
  • 3
  • 1
  • 4
0
votes
3 answers

Get the nth day of a year

For a homework assignment, I want to calculate the nth number of the day a date is in a year in a Jave program. So, a user gives a date, and then it tells what number of day this is in a year. So 1st of January 2019, is day 1. I already have a…
mathew
  • 61
  • 7
0
votes
2 answers

PHP datetime end of month minus one month

Of a given datetime I need the very end of the previous month. For example: $date_given = '2019-07-14 16:33:05'; should become: 2019-06-30 23:23:59 I have some possible solutions to make it in several lines. But the requirement for my…
DanielM
  • 317
  • 2
  • 11
0
votes
1 answer

Different if statement based on the first ID in a block of ID's in Excel (VBA?)

So basically I have an excel sheet featuring a number of different id's, dates, and a column where I would like to specify beginning middle or end in a 3rd column depending on the FIRST ID date. However this should only apply to the block of the…
Johnny Thomas
  • 623
  • 5
  • 13
0
votes
1 answer

How to single out values in a database based on date being month-end?

I have a problem where I need to query a database which includes multiple lines of trade activity for the past 90 days. Currently the query is built to determine the average amount over the 90 day period - so each day has a single exposure value and…
An Nuyen
  • 17
  • 5
0
votes
3 answers

finding first and last available days of a month in pandas

I have a pandas dataframe from 2007 to 2017. The data is like this: date closing_price 2007-12-03 728.73 2007-12-04 728.83 2007-12-05 728.83 2007-12-07 728.93 2007-12-10 728.22 2007-12-11 728.50 2007-12-12 728.51 2007-12-13 …
Arsalan
  • 333
  • 4
  • 14
0
votes
2 answers

Query to find day number of the fiscal month in oracle SQL

The query should return the day number of the current fiscal month.Check the below query: SELECT * FROM GL_PERIODS WHERE PERIOD_SET_NAME='Fiscal Year' AND period_year =(SELECT DISTINCT period_year FROM gl_periods …
Roly Singh
  • 27
  • 5
0
votes
1 answer

Pandas sorting by day

I have a pandas dataframe (dfm), I want to get the min by each day and have the resulted sorted by day. There are more one - Oct 4 or Jun 7....etc. dfmn count Month Day Data_Value 1 Nov 26 11 3 Oct 4 …
Rock
  • 1
  • 1
0
votes
3 answers

How to select the last day of selected months in daily data in EXCEL

I have daily data from 01-Jan-2005 till 29-Dec-2017. I want for each year to select the last day of March, June, September, and December, alongside their respective data. Part of the data: Date Variable 30-Mar-2005 1.2943 31-Mar-2005…
Hercules Apergis
  • 423
  • 6
  • 20
0
votes
1 answer

Does put_time Have a Conversion Specifier Which Outputs Single Digit Days of the Month Without a Preceding Character

put_time provides 2 conversion specifiers for outputting day of the month: %d: "Day of the month, zero-padded (01-31)" %e: "Day of the month, space-padded ( 1-31)" Note that neither of these conversion specifiers will allow me to output a…
Jonathan Mee
  • 37,899
  • 23
  • 129
  • 288
0
votes
3 answers

Is there a function to provide the first day of the month?

In Java I can get the first day of the month by this way: GregorianCalendar date; // Some code int first = new GregorianCalendar(date.get(Calendar.YEAR), date.get(Calendar.MONTH), 1).get(Calendar.DAY_OF_WEEK); I'm wondering if there a…
user6490462
0
votes
2 answers

How to only get the day from the date stored in database in java?

I can retrieve the complete date of all the records but I only want to retrieve the day of each record. For example I have a date 2017-01-20, but I only want to retrieve 20. How do I do that? Here is my code: SimpleDateFormat sdf = new…
PG20
  • 67
  • 1
  • 2
  • 10
0
votes
1 answer

How can we get previous and next months with full days continuously using moment js?

I have two buttons for getting next and previous months with fulldays. I have included moment js. At-present when I click on next button I am getting December and end date is 28th, then I click again getting the same month not January. When I click…
Sarath TS
  • 2,432
  • 6
  • 32
  • 79
0
votes
1 answer

Calculating when the next payment is due, taking February into consideration

I am trying to create a program that notifies me the day a payment is due. I pretty much have an idea on how it's done but one issue remains. Let's say that the customer opened the account on 1/31/17. The next due date is 2/28/18(a month later). My…
Javier Calderon
  • 1
  • 3
0
votes
2 answers

Set a date variable that equals to previous month's full month

This is probably a silly question. Is it possible to set a variable value that I could use to get data from the previous month's days? For example, if it's the 24th of September, I want everything from the 1st of August until the 31st of August. So…
user8166711
1 2 3
4
5