last day from date

smohd1338 · Post by **smohd1338** » Wed May 08, 2013 7:56 pm

i get yyyymmdd format date , i need output as yyyymmdd(but dd has to be last day of month 'mm', is there a direct funtion to pull last day of any month,

For Example: Input filed = 20130814, then output should = 20130831

smohd1338 · Post by **smohd1338** » Wed May 08, 2013 8:24 pm

i foud, looks like daysinmonth should work

smohd1338 · Post by **smohd1338** » Wed May 08, 2013 8:55 pm

there is no daysinmonth function in 8.1? how shall i write vthe loic without going into if then else

chulett · Post by **chulett** » Wed May 08, 2013 9:07 pm

Well... you could always play the old game of setting the date to the first day of the next month and then subtracting one day from it.

You could also build yourself a "DaysInMonth" routine... only four possible answers after all with some pretty well-known rules for the only one that is a variable.

priyadarshikunal · Post by **priyadarshikunal** » Thu May 09, 2013 11:18 am

May be you can start from here.

ray.wurlod · Post by **ray.wurlod** » Thu May 09, 2013 4:45 pm

Code: Select all

Field("31|28|31|30|31|30|31|31|30|31|30|31", "|", MonthFromDate(InLink.TheDate), 1)

is a quick way (ignoring leap years) to get the day number of the last day of the month. You can then build the date from components. Use an If..Then..Else derivation for the list to set the last day of February to 29 if it is a leap year.