how to remove timestamp from monthend function?

[#1]

Hi all,

Please an some one help me out with the below issue??

In my script I have a row as below:

Monthend(Month)   as expiry_date,

the  expiry date resultant is presently as 31/1/2016 11:59:59 PM but I want to remove the time stamp from the same in the script level or make the timestamp 0,so that my out put comes after reloading as only 31/1/2016.How is this possible?? please can someone help me??

regards,

Sahana

[nilo_pontes]

Hi Sahana,

Try: Date(Floor(Month),'DD/MM/YYYY') As expiry_date.

Take a look at Primer for QlikView Date fields for more details.

Regards

[Anonymous]

Hi,

Try below,

Date(Floor(MonthEnd(Month))) as Expiry_Date

[SunilChauhan]

Date(Monthend(Month))   as expiry_date,

[jagan]

Hi Sahana,

Try like this

Date(MonthEnd(Month))

or

Date(MonthEnd(Month), 'M/D/YYYY')

OR

Date(Floor(MonthEnd(Month)))

Regards,

Jagan.

[#6]

hi thanks a lot

how can I do the same foe today() function in chart level.

I tried this:expiry_date-Date(Floor(today()))) it works ,but when I do

(expiry_date-Date(Floor(today()))))/365 it doesn't work... the time stamp doesn't become 12:00:00am

Please can you help me??

[SunilChauhan]

Date(expiry_date)-Date(today())

[SunilChauhan]

or you can try

age(expiry_date,today())

[tresesco]

Today() returns an integer, so the floor() would not be required for it. Rather try like:

Floor(expiry_date) - today()

But again if you divide the returned integer by 365, you might not get an integer. I could not understand the logic of expecting output 12:00:00.

[its_anandrjs]

Try with

Date(Floor(Month),'DD/MM/YYYY') As expiry_date  // If you need the DD/MM/YYY formats