Date Format Doubt

njaiku

Hi Everybody,

I have a doubt regarding the date format.
Suppose if i have a date field in the format as dd/mm/yy.
Now my business person needs the date to be in this format
(mm/yyyy) . Is it possible?


If anyone knows, please do the needful as soon as possible.

Regards,
Jai

Malajlo

You cant use data in date field to only mm/yyyy. But you can use format property to show only month/year.

NaviDev

You can achieve what you want by using format command.

try this code

MESSAGE(FORMAT(TODAY, 0, '<Day,2>/<Year4>'));

njaiku

Hi,
Thanks for replying . But i have a field in the form like

Monthoff (MM/YYYY)

In this field i must allow the user to enter in this format (MM/YYYY).

I have a doubt , whether this field is to be Date datatype or any other
datatype. Moreover where should i do the coding