>Is there function in VFP or in contributions which for given number of days from the year beginning will return month or day of month it falls on or just a {date}.
>
>
>
>TIA
>Michael
I am not so sure what you asking for, but try this:
? DaysFromStart(123, 2005)
? DaysFromStart(123)
? DaysFromStart(123, 2008)
FUNCTION DaysFromStart(lnNumberOfDays, lnYear)
IF VARTYPE(lnYear) # [N]
lnYear = YEAR(DATE())
ENDIF
IF VARTYPE(lnNumberOfDays) # [N]
MessageBox([And what you want :-)?])
ENDIF
RETURN DATE(lnYear, 1, 1)+lnNumberOfDays
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.