Skip to Content
0
Aug 07, 2019 at 03:26 PM

Date Variable Help: Where date1 > FormatDate(Date2;"dd/Mm/yyyy")

75 Views

Hi All,

I am trying to calculate the below formula in a variable but get the following error: "The expression of sub-expression '>' function uses an invalid data type".

Can someone please explain what I am doing wrong here?

=If ([Migration Date \[Y/N\]] = "Y" And [Linkyfi Frist CDR Date \[Y/N\]] = "Y" And [Linkyfi First CDR] >= FormatDate([Migration Date]);"dd/MM/yyyy") Then "Y" Else "N"

Date1 Format = dd/MM/yyyy

Date2 Format = dd/MM/yyyy hh:mm

Thanks