Convert date string containing a month text value to a date value

Assuming you want to enter date values in the RTC client like 15-MAR-14. that won’t work. date values are only accepted with syntax like 15.03, 15.03.14, etc. But it can be that users prefer the above syntax. so then you can use a text field in your page and convert internally the value into a date… Continue reading Convert date string containing a month text value to a date value

Date Functions

Date functions are quite often used and needed. Here are some samples: Calculate the 1st of current month: EndDate := CALCDATE(‘-CM’); Calculate last day of current month: EndDate := CALCDATE(‘CM’); Calculate the end date of a defined period (e.g.3 months) starting with the 1st of the current month; get the last day of the end month: EndDate := CALCDATE(‘-CM+3M-1D’);… Continue reading Date Functions