Forum Discussion

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

DATEDIFF incorrect - not sure why

Hi all, I have the following matrix table in my report: The Unexpired Lease in Days column contains the following:     Unexpired Lease in Days = VAR _asofdate = [As Of Date] VAR _leaseend...
Need Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    julesdude 

    Not sure the reason for using the FORMAT function. However, please try

    RETURN
    _targetdate


    Or


    RETURN
    DATEVALUE(FORMAT(_targetdate, "dd/mm/yyyy"))

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

julesdude 

Not sure the reason for using the FORMAT function. However, please try

RETURN
_targetdate


Or


RETURN
DATEVALUE(FORMAT(_targetdate, "dd/mm/yyyy"))

julesdude's avatar
julesdude
Icon for Post Partisan rankPost Partisan
3 years ago

Thanks tamerj1 

It worked simply with replacing the FORMAT line as per your suggestion, and just use:

RETURN

_targetdate

It is really strange - I had put this in originally because I could not select the Format of the measure as a date at the time. but it now gives me the option to Format as a date now that I've removed the FORMAT line. 
Anyway, many thanks for your help! The format change now provides the correct calculations: