Hello
I've added this line in my macro to ask user to input the date. It repeat two times in my macro .!!
I 've changed it many many times .but ... .I have the same code in another database which comes up one time !
could you help me what is wrong ?( the correct date should be 2022-01-01 : first day of the month )
UPDATE [Report_Date] SET [Report_Date].[Date] = DateSerial(Year([report Date (ex: 1 Jan 2022)]),Month([End Date (ex: 1 Jan 2022)]),Day([End Date (ex: 1 Jan 2022)]));
Thank you so much
I've added this line in my macro to ask user to input the date. It repeat two times in my macro .!!
I 've changed it many many times .but ... .I have the same code in another database which comes up one time !
could you help me what is wrong ?( the correct date should be 2022-01-01 : first day of the month )
UPDATE [Report_Date] SET [Report_Date].[Date] = DateSerial(Year([report Date (ex: 1 Jan 2022)]),Month([End Date (ex: 1 Jan 2022)]),Day([End Date (ex: 1 Jan 2022)]));
Thank you so much