Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find a date ??

How to find a date throgh expression

Date(17/09/2012) + 60 days = Result Date

4 Replies
Not applicable
Author

Hi,

use this expression:

=

Date(Date#('01/01/2013','DD/MM/YYYY') + 10)

Niranjan M.

Not applicable
Author

hi

see attachement

=Date(Date#('17/09/2012','DD/MM/YYYY') + 60)

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

=Date(Today() + 60)

Regards,

Jagan.

er_mohit
Master II
Master II

try this

Date(Date#(TempDate,'DD-MM-YYYY')+35)

here TempDate is my date field

you could also write today() replacing field and manually date also but in your date format ..

hope it helps