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!
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.