Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

Round dates down

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Round dates down

hello

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

Regards,

View solution in original post

5 Replies
Highlighted

Re: Round dates down

hello

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

Regards,

View solution in original post

Highlighted
krishna_2644
Valued Contributor III

Re: Round dates down

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

Captur1e.PNG

see attached file.

Highlighted

Re: Round dates down

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

Highlighted
Not applicable

Re: Round dates down

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

Thanks for helping out.

Highlighted

Re: Round dates down

You are welcome Sarb.

Regards