problem with date

[Anonymous]

Hello,

I have a problem with weekstart function.

I had written a function for date column and it is not working as per my requirement. The formula is

=weekstart(date([Time Full Date],'DD/MM/YYYY'),0,-1)

and it is resulting  like below

here for jan,feb,march zero's are not appearing. But I need like

01/18/2015

02/08/2015

pls help me on this one.

Regards,

Kumar

[qlikmsg4u]

Try this

=weekstart(date([Time Full Date],'MM/DD/YYYY'),0,-1)

[robert_mika]

How does your data look like?

[Anonymous]

data is good.

[Anonymous]

I tried that also.

[qlikmsg4u]

post your input sample data

[Anonymous]

Qvd file size is huge. basically I am new to Qlikview. can you tell how to limit no of records in qvd.

[rubenmarin · Accepted solution]

Hi Kumar, you can try this:

Date(weekstart(date([Time Full Date]),0,-1),'MM/DD/YYYY')

Note than the Date() is enclosing the weekstart function, so the date returned by weekstart instead of the default date format will apply the one we specified.

[Anonymous]

Thanks a lot. It resolved my issue.

regards,

Kumar