Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

max(Date)-1 not working

Hi Experts,

Can any one please help me on below requirement. I have a date field like DD MMM YY Format

for max(Date) getting 22 Feb 18 correctly but for Max(Date)-1 getting 43152 instead of 21 Feb 18.

Please help me on converting number to 21 Feb 18 format

Thanks in advance

1 Solution

Accepted Solutions
ashwinishinde
Partner
Partner

Try this,

=date(max(Date)-1,' DD MMM YY')

View solution in original post

5 Replies
YoussefBelloum
Champion
Champion

Hi,

try this for Max date -1:

=Date(Max(Date)-1)

shiveshsingh
Master
Master

Try Date(Max(Date)-1)

ashwinishinde
Partner
Partner

Try this,

=date(max(Date)-1,' DD MMM YY')

View solution in original post

buzzy996
Master II
Master II

pfa

isingh30
Specialist
Specialist

Please check this.

The Date Function

Thanks.