Access Query (SQL)

How to compare a date with another date which is generated by (dateserial) formula in SQL Query when:
Dateserial (year(date()),month,day) 'year is taken from other date in the same query
The result of this formula is not a valid date
I tried CDate (Dateserial (year(date()),month,day)) but still the result is not a valid date
I am checking by IsDate formula and the result is -1 (means it is not a date)
and if I compare it with any other date the msg (data type mismatch) is appearing
Any body knows how to get the result converted to a date so that I can compare this result with any other date?

Share : Share

0 comments

More from Qatar Living

Qatar’s top beaches for water sports thrills

Let's dive into the best beaches in Qatar, where you can have a blast with water activities, sports and all around fun times.

Most Useful Apps In Qatar - Part Two

This guide brings you the top apps that will simplify the use of government services in Qatar.

Most Useful Apps In Qatar - Part One

this guide presents the top must-have Qatar-based apps to help you navigate, dine, explore, access government services, and more in the country.

Winter is coming – Qatar’s seasonal adventures await!

Qatar's winter months are brimming with unmissable experiences, from the AFC Asian Cup 2023 to the World Aquatics Championships Doha 2024 and a variety of outdoor adventures and cultural delights.

7 Days of Fun: One-Week Activity Plan for Kids

Stuck with a week-long holiday and bored kids? We've got a one week activity plan for fun, learning, and lasting memories.

Wallet-friendly Mango Sticky Rice restaurants that are delightful on a budget

Fasten your seatbelts and get ready for a sweet escape into the world of budget-friendly Mango Sticky Rice that's sure to satisfy both your cravings and your budget!

Places to enjoy Mango Sticky Rice in high-end elegance

Delve into a world of culinary luxury as we explore the upmarket hotels and fine dining restaurants serving exquisite Mango Sticky Rice.

Where to celebrate World Vegan Day in Qatar

Celebrate World Vegan Day with our list of vegan food outlets offering an array of delectable options, spanning from colorful salads to savory shawarma and indulgent desserts.

My account

My saved ads

My saved searches

Logout

Access Query (SQL)

More from Qatar Living