
Creator III
2013-12-07
12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make date
Hi,
I have Year and Month
Year Month
2013 9
2013 8
2013 3
2013 4
How to make date ............
- Tags:
- new_to_qlikview
540 Views
3 Replies

Anonymous
Not applicable
2013-12-07
01:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Paul
date(date#([Year] & num( [Month] ,'00'),'YYYYMM'))
Best Regards, Bill
366 Views

Not applicable
2013-12-07
03:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try with MakeDate function like below:
MakeDate(Year,Month) AS DATE_FIELD

MVP
2013-12-07
04:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
MakeDate (Year, Month, 01) AS Date
If 01 dont work use '01'
366 Views
