Round dates down

[#1]

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

[julian_rodriguez · Accepted solution]

hello

If your field is called MyDate, use MonthStart(MyDate)

Regards,

[Qrishna]

if you date format is 'dd/mm/yyyy' then convert the format to 'yyyy-mm-dd' and the use Monthstart(Date).

see attached file.

[julian_rodriguez]

If the field is numeric and Qlikview can interpretate it as a date,  functions like monthstart will work, no matter the date format.

[#5]

Thanks Julian. It worked perfectly without changing formats. My dates were DD/MMM/YYYY.

Thanks for helping out.

[julian_rodriguez]

You are welcome Sarb.

Regards