Date fields

[AMH]

Does anyone know how you can get at the day part of a date field and then move a value to it

eg dd/mm/yyyy move 01 to dd

 

[R. Hicks]

What you ask can be done, but it will look nasty. I assume what the end result you are after is to calculate the first day of the month for the date entry you have. If this is true then use the example below to get your result:

=DateSerial(Year([YourDateEntry]), Month([YourDateEntry]), 1)
("YourDateEntry" should be the name of the control that contains the data to be evaluated)

HTH
RDH

[This message has been edited by R. Hicks (edited 08-03-2001).]