Displaying MMM-YY correctly when exported to Excel

[SamWeatherby]

Hi

I have a datetime field being displayed as 'MMM-YY' in a straight table chart. My service users are required to export this data into Excel (likely to create their own pivots from) but when doing so, this field is displayed alphabetically (Apr-22, Aug-22 etc.). I have tried the following two date functions in Qlikview which results in the same alphabetical display when exported to Excel:

1) =MontName([Field])

2) =Date([Field],'MMM-YY')

Is there an alternative function that would make Excel see this as a date whilst maintaining the 'MM-YYY' format?

Thanks

Sam

[sergio0592 · Accepted solution]

Hi,

In Qlikview try with interpreting function :

=Date#(Field,'MMM-YY')