Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have set of dates,
1/3/14
3/3/14
5/3/14
20/3/14
I want to round all the dates down to 1st of the month.
Can someone help me how can i do it?
Thanks
hello
If your field is called MyDate, use MonthStart(MyDate)
Regards,
if you date format is 'dd/mm/yyyy' then convert the format to 'yyyy-mm-dd' and the use Monthstart(Date).
see attached file.
If the field is numeric and Qlikview can interpretate it as a date, functions like monthstart will work, no matter the date format.
Thanks Julian. It worked perfectly without changing formats. My dates were DD/MMM/YYYY.
Thanks for helping out.
You are welcome Sarb.
Regards