IBM Mainframe Forum

[jvinoth]

How to get the month's start date by giving the current date..please tell me how to get this using the sort..

suppose if we give the particular date we need to get the that date's month starting date...
thank you so much.

[prino]

Every month starts on the first, what's your problem?

[BillyBoyo]

What format is your input date? Have you considered just setting the DD part of the date (if yours contains that) to '01'?

However, does it matter if that is a weekend/holiday?

[jvinoth]

mm/dd/yy format and its k if its weekend or holiday.

[BillyBoyo]

In mm/dd/yy, mm/01/yy is always the first day of the month.

Select all

  OVERLAY=(startpositionofday:C'01')

Would make the date the first of the month.

If you ever need the last day of the week, month, quarter or year, there are DFSORT functions for those. There are other DFSORT date functions, and it is worth familiarising yourself with them if you are doing date processing. There are further date manipulations in the Smart DFSORT Tricks book, available on the web.