date from month -int (4)

ovidiu · Post by **ovidiu** » Tue Mar 28, 2006 9:41 am

Does anybody know a simple method to get a date- month.year-from a number month int(4)

Thank you

ArndW · Post by **ArndW** » Tue Mar 28, 2006 10:22 am

There is no single builtin function in PX to let you do this. You will need to convert your Month number (based on what first month?) into an actual date and then use the [bold]DateFromDaysSince[/bold] to get a number of date using a average of 30 days/month, or use 29 and accept a possible error on rounding down if there are more than 31 months between the two dates. Correct would be to write your own offset math working on the yy and mm initial values, adding your months and wrapping after month 12 and adding 1 to the year. Finally, putting the new yy and mm values together with a day of 1 to get a value which can be converted to date format.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 28, 2006 3:10 pm

Convert the number to a string, add a day number (such as "01") in the appropriate location for your date format, then use a string to date conversion function.

ovidiu · Post by **ovidiu** » Tue Mar 28, 2006 5:43 pm

Thanks for the answers...I just found a string date to relate to ...but is good to know.
Thanks again