Multiple Date columns

[Pandurules]

Hi,

I have multiple Date fields like,  AdmissionDate, DischargeDate,AppointmentDate, BookingDate and so on for past 10 years,  in a Single Table. How could i write the script to load the dates only for the year 2020.

Should be done in Backend.

[MarcoWedel]

for example

... Where Year(AdmissionDate)=2020

?

[Pandurules]

there are more than 15 date field columns

[Vegar]

You will need some kind of where statement, but you also need to decide on how to handle transactions where one of the dates fields are in 2020 but another field is 2019 or 2021.

[Pandurules]

AdmissionDate, DischargeDate,AppointmentDate, BookingDate have dates starting from 05/13/2013 to till date, i need to select dates which belong to the year 2020 using backend, where in front end can be done set analysis.

[MarcoWedel]

please post some sample data and your expected result