Select 1st day of the month to the middle day of the month

Help
1

Is there any way to select the first day of the month And the middle day of the month?
i found the solution for retrieving the first day but not for the mid of the month.
If possible could i select the range too?

2

@Martin_Pan

Add 14 days to first day of month then you will get Middle day of the month.

1 Like
3

okay thanks, i have another question too, if i have a string values with like ‘Mar’ ‘Apr’ ‘May’ and so on, i would like to convert them back to like date (or datetime) format for calculation of some date stuff. How can i do that?

4

@Martin_Pan

Datetime.parseexact(“Mar”,“MMM”,system.gobalization.cultureinfo.invariantculture).tostring(“MM”)

1 Like
5

wait but i need it to be back into a date for calculation

6

Check how many days are in the month and find the half

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.