Dates

[B_Y_ID8]

Hi all,

I have an excel file that has a multitude of dates that sit in Column (Form Submit) in different formats: ie some are dd/mm/yyyy hh:mm:ss and some are yyyy/mm/dd hh:mm:ss.

I am trying to get only the values that are -14 from todays date and that Form Submit fall into. ie 13th Oct onwards to todays date.

So my filter is: [Form Submit] >= DateTimeAdd(DateTimeNow(), -14, "days") - Anything that is true to carry over.

However the results are still picking up dates that are not within the 14 day timeframe.

I have to note that the input file for this has specified the Form Submit as a V_String also.

Where am I going wrong? Any help would be appreciated.

Thanks

[atcodedog05]

Hi @B_Y_ID8 

Can you provide sample of your data and if possible your workflow too.

We will be happy to take a look into it 🙂

[Emil_Kos · Accepted solution]

Hi @B_Y_ID8,

From your message, it isn't clear for me did you changed those string type to a data type?

If no you need to do this in order to make your formula work properly.

[Emil_Kos]

Hi @B_Y_ID8,

Thank you for marking my post as an answer.

Good luck!