Date comparison

Occasional Contributor

Date comparison

Hi all,


I've got a line item where I import date from AWS everyday. I also have a list called Split Week where I have two 'Date' formatted properties called Start of Week and End of week. 


Is there any way I can check if the Date of import lies within the 2 properties?


Thanks in advance.



Message 1 of 3
Super Contributor

Re: Date comparison



you can use the standard comparison operators > < >= <= between Date formats or Period formats

Nathan Rudman
Anaplan Model Builder
Message 2 of 3
Certified Master Anaplanner

Re: Date comparison

HI Prateek,


You can do a comparison by using operators >,<,<=, >=,<> etc.. between dates.


Add a new property in the list and put the comparison formula as shown below.


Untitled picture 1.png                                                                                                                                                                                                                                        Untitled picture 2.png                                                                                                                                                                                                                                                                                                                                     Untitled picture.png


Hope this would be helpful!!





Message 3 of 3