I would like to be able to give any date in the dd-mm-yyyy (or whatever you choose) and return the Day of the Week.
E.g.
firstofthemonth = GetDay(01-10-2011)
result: Saturday
or
endofthemonth = GetDay(31-10-2011)
result: Monday
---
As good as the Date functions are you cannot do a great deal more, I'd love to be to do this as well:
tomorrow = GetDateNum(#DATEDAY,1)
result: 1 (the day after tommorow)
Or
yesterday = GetDateNum(#DATEDAY,-1)
result: 30 (the day before today)
Same goes for the other GetDateNum() constants:
e.g.
nextmonth = GetDateNum(#DATEMONTH),1)
result: 11 (the next month)
----
Or even....
noofdaysinthismonth = GetDays()
result: 31
And finally..
weekno = GetWeek()
result: 44 (final week of november)
Thanks