How to convert the date

[#1]

Hi All,

In my Database, the date format is 2013/01/01

How can I show it in QV with 2013-Jan?

Thanks.

[MK_QSL]

Date(YourDateField,'YYYY-MMM')

[MK_QSL · Accepted solution]

Or something like this...

=Date(Date#('2013/01/01','YYY/MM/DD'),'YYYY-MMM')

[#4]

Hi,

      Year(YourDateField)&'-'&Month(YourDateField) as Date_field;

Hope this helps you.

Regards,

Divya

[#5]

Hi,

You can use the following;

date(MonthName(date),'YYYY-MMM')

HTH

-Shruti