Subtracting Numeric Value from Date Value

[gico1972]

Need help in my query to subtract [Days] (Numeric Value) from a date field [TravelDate]

Appreciate any help.

Regards

 

[spikepl]

Find the appropriate date function : http://www.techonthenet.com/access/functions/

 

[gico1972]

Perhaps i was not clear.

I have 2 fields [Date of Trave] and [Days]

I just want to know what the expression would be for a calculated field.

[Date of Travel]-[Days]
25-sep-15 - 14

 

[CJ_London]

you need to understand what a date field is - it is a form of double, not a string

25-sep-15 is a string

As spike says, choose the appropriate date function for your needs - in this case it would be a dateadd function. Look this up and understand it before you say 'but I want to subtract it'

 

[Minty]

You can use the DateAdd function to subtract, just use a - before your [Days] field

MyNewDate = DateAdd("d",-[Days],[Date of Travel])