Variable Month in function Inmonth

[sculptorlv]

Hello!

I usually use great function InMonth:

          InMonth ( date, basedate , shift )

And now I have problem, because I need to use this function again, but I don't have a 'basedate' ... I have only variable with MONTH (not full date)

How can I put this variable .. let say vMonth  .. into this function or which another function I can use for the same result??

Thank you.

[sunny_talwar · Accepted solution]

May be create an imaginary date from your Month:

MakeDate(Year(Today()), MONTH) as BaseDate

and then use this in the preceding load:

InMonth(date, BaseDate, shift)

[sculptorlv]

Thank you