Need help in sql where condition - Qlik Community

Report Inappropriate Content · ‎2014-08-25

Hi Guru's,

As I need a 'YYYYMM' format of date in the SQL WHERE condition.

like in our Load statement we can write

Date(MonthName(PurchaseDate),'YYYYMM') as PurchaseDate but I want the same expression in sql Where condition.

How do i write that

PrashantSangle · ‎2014-08-25

Hi,

If you need SQL function for it

then use

to_char(trunc(sysdate),'yyyymm')

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 🙂