Date-time and Days Difference

[AJ-CH]

Hello, 

Looking for a solution for the difference of StartDate-Days

StartDate field is V_String. Always want to see a 280 days prior date to start Date. The output should be in #Days

Tried "DateTimeDiff([Expected Delivery Date_Out],'280','days')"

[MarqueeCrew]

But did you try:

DateTimeAdd([Expected Delivery Date_Out],'-280','days')"

 cheers,

 mark

[CharlieS · Accepted solution]

The DateTimeDiff( function is used to quantify the quantity of units between two date time values (Ex: the quantity of days between two date values.). In this case, you want to use DateTimeAdd( to return the date value result of adding (or subtracting) units. 

DateTimeAdd([Expected Delivery date_Out],-280,"days")

[AJ-CH]

this is the formate of my data:

Expected Delivery Date (V_String)
1/25/2017 12:00:00 AM

when used the formula you provided, it is showing Null values.. please suggest 

[NickSm · Accepted solution]

@AJ-CH 

I'm guessing the issue is likely because the datetimeadd formula isn't recognizing the incoming field as a date. Try using a date-time tool or formula to format to a Date datatype, then using that calculation.

Example attached

[AJ-CH]

Worked.. thanks