Dealing with leap years in accounts

Discussion created by weedonpaul on Feb 10, 2017
Latest reply on Feb 10, 2017 by weedonpaul



I have to submit VAT returns end of FEB, MAY, AUG and NOV


I am want the user to select month and year from drop down lists to be used in a script to calculate the VAT return, both month and year are stored as text in a lookup table


I want it so that the choice is then changed into a date format of the last day of the month


eg user selects MAY and 2017 it returns 31/05/2017


The problem is February and leap years


My solution is to go to the first of the following month and subtract 1


user selects FEB and 2017 it returns (01/03/2017)-1 and stores it as 28/02/2017

user selects FEB and 2020 it returns (01/03/2017)-1 and stores it as 29/02/2020


will that work? and how would I go about it?