Walter Meester
HoogkarspelNetherlands
Andrus,
>>mdate2=gomonth(date()-day(date())+1,1)-1
>I want to say that this last code is also wrong:
>it will not work for year 9999 which I use
to mark special dates.
>Is it possible to have a simple function which works in 9999 also ?
It only goes wrong the the date is in the last mont of the year 9999
to solve this problem you could say this:
mdate2=IIF(date() > {30-11-9999},{31-12-9999},gomonth(date()-day(date())+1,1)-1)
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only