query to update field with combined values from another

[tagteam]

This should be easy but I cant seem to get it.


I have a table that has three fields: AllowedCentury, AllowedYear and AllowedMonth. I created a new field called RealDate and I want to use the Century , Year and Month fields to update it .

I have tried to concatentate:
[AllowedMonth] & "/" & 1 & "/" & [AllowedCentury][AllowedYear]

But that doesn't work.
I have looked at using date part but it is in three different fields.

Any Ideas how to update this field using and update query and get a real date field entered?

[tagteam]

Sorry, of course as soon as I post it I figure it out.

I needs to be :RealAllowed: [AllowedMonth] & "/" & 1 & "/" & [Allowedcent] & [AllowedYear]

I need the ampersand in between the last two fields

[Minty]

You could also use the DateSerial(year, month, day) function, Which seems a little more intuative to me;

ReallAllowed: DateSerial([Allowedcent] & [AllowedYear],[AllowedMonth],1)

https://learn.microsoft.com/en-us/of...erial-function

[ArviLaanemets]

I needs to be :RealAllowed: [AllowedMonth] & "/" & 1 & "/" & [Allowedcent] & [AllowedYear]

Btw. what you get is not a date, it is a datestring! I.e. a text value! And Except in case AllowedMonth field is a 2-character string like '01', you cant compare them properly ('11/1/2023' is less than '2/1/2023', or 'August/1/2023' is less than 'January/1/2023', and anyway e.g. '01/01/2023' is less than '02/01/2000')!

DateSerial(...) returns a real date!