General information
Category:
Coding, syntax & commands
>>>Is there a function to get the number of days in a month.
>>>eg. the number of days in any month of any year.
>>>
>>>Thanks
>>>Andrew
>>
>>Sometime ago I wrote a 10 line function to simply determine the last day of the current month. I kept adding days until the date function determined the data was invalid. Something like this:
>>...
>>For I = 1 to 31
>> lcChkDate=Month...+"/"+STR(I,2)+"/"+Year...
>> ...
>> IF DATE(lcChkDate)=" / / "
>> * Invalid Date take Previous I (Day) (I-1)
>> * as last Day of Current Month
>>
>> * Define variable here ldDate=DATE(lcChkDate)
>> EXIT
>> ENDIF
>>Endfor
>
>You may wanna take a look to one my FAQs in the KB. It can be done with a simple one line formula.
>
>Vlad
Why don't you use
day(gomonth(xdate ,1) - day(gomonth(xdate ,1))) && xdate is a date value
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