Date Not Read Correctly in Formula Tool

[727]

Looking for some help configuring my dates in the below formula tool.

We have 3 different start dates - 2/1/2023, 5/1/23 and 9/1/23. The issue I am having is with the classification of the 5/1 start dates - they are being tagged as '1st Partial' but should be '1st' - any idea why?

The date is feeding in as a vstring in M/D/YYYY format. 

Appreciate any help!

[Luke_C]

Hi @727 

You'll need to make sure that [Start Date] is in YYYY-MM-DD format and has the date datatype for this to work. You can use a date tool or a datetimeparse() function to do this. For example:

DateTimeParse([Start Date],'%m/%d/%Y') would address the format you mentioned.