Discussion board where members can get started with QlikView.
I have set of dates,
I want to round all the dates down to 1st of the month.
Can someone help me how can i do it?
If your field is called MyDate, use MonthStart(MyDate)
View solution in original post
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.