topic Round dates down in QlikView

Round dates down

Thu, 13 Aug 2015 20:19:20 GMT

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 — Thu, 13 Aug 2015 20:31:38 GMT

hello

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

Regards,

Qrishna — Thu, 13 Aug 2015 21:01:04 GMT

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 — Thu, 13 Aug 2015 21:11:01 GMT

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

Thu, 13 Aug 2015 21:43:09 GMT

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

Thanks for helping out.

julian_rodriguez — Thu, 13 Aug 2015 21:45:56 GMT

You are welcome Sarb.

Regards