Hello all,

I am new to this and new to FM Products. In the coming time, I hope to learn to use FM, in due time I even hope to get nearly as good as some of yous are

I hope that you people will tolerate me asking horrible newbie questions for the time being.

What I would like to do, specifically, on this occasion: I would like to make a date field, in which only the month and the year are visible.

Can anyone give me some pointers?

Hi Ano,

You can create another calculation text field which capture the month and year.

for example, if the date format is mm/dd/yyyy (01/18/2003)

then the calculation you can set it as:

Left(DateToText(date), 2) & Right(DateToText(Date), 5)

So the result will be 01/2003

You can just use the Text functions(left, middle, right) to capture the data which you want.

Regards,

Henry

If you want to display the month and year on a layout; add your date field on the layout and use the format , date option to only display the month and year.

If you have to have a field then try Month(DateField)&"/"&Year(DateField).

NB. This is a text result not a date.

just like Robert said, if you can just change the date format, this is the simple way.Thanks for Robert advice. This is more simple that my solution.

For my solution just now, you can use it in other cases like filtering technique. For example, phone number, user key in numeric number but you can add a "-" between the area code and phone number.

Regards,

Henry

That did the trick, thanks guys