Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
The date format(DD-MMM-YY) is fine When I read the data from QVD.
But when I exract the max date from the same QVD, it's not being fine.It shows in number format(41813).
Please can someone help me out in this where am wrong .
Thanks !
Nothing is wrong. Your date is a dual value, the text part shows the date formatted DD-MMM-YY, but there is an underlying numeric part.
Please read
Max() calculates the maximum number, returning a number. To format as date again, use Date() function:
=Date(max(DateField),'DD-MMM-YY')
Nothing is wrong. Your date is a dual value, the text part shows the date formatted DD-MMM-YY, but there is an underlying numeric part.
Please read
Max() calculates the maximum number, returning a number. To format as date again, use Date() function:
=Date(max(DateField),'DD-MMM-YY')
Great!! Thanks swuehl for ur quik response.!