Solved: Date to Text - Qlik Community

kevbrown · ‎2014-11-11

I'm looking to change my "start" date to be in a text format so "mmm-yyyy". I only need the min of the start date. I was trying -

Min(month(Date#(Start, 'mmm-yyyy')))

but it's not working, ideas?

Kev

ali_hijazi · ‎2014-11-11

MonthName(min(Date))

I can walk on water when it freezes

View solution in original post

PrashantSangle · ‎2014-11-11

Hi,

Try lilke

Min(month(Date#(Start, 'MMM-YYYY')))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

senpradip007 · ‎2014-11-11

Try like month(Date#('Nov-2014', 'MMM-YYYY')) or Date(Date#('Nov-2014', 'MMM-YYYY'), 'MMM')

ali_hijazi · ‎2014-11-11

MonthName(min(Date))

I can walk on water when it freezes

kevbrown · ‎2014-11-11

Thanks

raviityou · ‎2014-11-11

hi,

try this one

=Date(max([Date_FKDAT]),'MMM-YYYY')

Date to Text

Related Topics