How to Fetch Dates from Database between two dates?

Help
1

image
image1440×900 73.1 KB

here i am getting this error for this query
"select holiday_date from blockchainrmgdb.holiday_calender_master where holiday_date between "+ TodaysDate.ToString + “and” + convertdatetime.ToString

2

@sup_93

Try this it might work.

select holiday_date from  blockchainrmgdb.holiday_calender_master where 
             holiday_date  between '"+value1+"' and '"+value2"'

or

select holiday_date from  blockchainrmgdb.holiday_calender_master where 
             and holiday_date >= '"+value1+"' and holiday_date <= '"+value2+"'

Regards,
Mahesh

2 Likes
3

yea… Its working…
Thank You :slight_smile:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.