How to get the first and last days of the month?
I would like to get the first day of the month and the last day of the month and use them as the criteria for Validate.
For example;
To allow only the input of dates from July 1st to 31st, the dates July 1st and 31st are acquired.
When I checked, I thought that Function "getStartAndEndOfMonthOfGivenDate" could be used,
but I think that the time may be obtained instead of the desired date.
Look at the line "3,4,10,11" of Java in the 4th step of Activity "pyAggregatePerformanceMonth" where this function is used.
Since the result is stored in a variable named "Time", I think that the time may be obtained instead of the desired date.
If you know it, I would be grateful if you could teach me.
Thank you.
***Edited by Moderator: Pallavi to update platform capability tags***
Blue Rose Technologies
DE
Hi,
Can you use one of these expressions given below? Only if you give input as any date from July 1 to July 31 it will give July as month. Same case for other months. You can have your validation using the month value it returns.
Or if you want to get month number.
HCL Technologies Limited
IN
Hello,
Can you give try to below function. It will return first date and last date of month.
@DateTimeUtils.pyGetStartOrEndDate("currentmonth",false,true)-> This will return last date of month
@DateTimeUtils.pyGetStartOrEndDate("currentmonth",true,true)-> This will return first date of month.
Further Checking the java code of the above function, i could see it accepts 3 inputs as below:
pySymbolName-> ( can be yesterday,today,currentmonth,today,tomorrow,yesterday etc)
bGetStartPeriod-> True or False
bGetDateFormat-> True or False
Hope it helps.
Thanks,
Bala