check null or empty value in datetime field
Posted: Fri Aug 20, 2010 10:51 pm
Hi
I want to check the null or empty value in report to datetime field .
This is my statement.
Switch(
Hour(DownloadTourMaster.FinalDuration) * 3600 + Minute(DownloadTourMaster.FinalDuration) * 60+ Second(DownloadTourMaster.FinalDuration)
)
I am checking like this.
Switch(
(int)Hour(DownloadTourMaster.FinalDuration) >0,
Hour(DownloadTourMaster.FinalDuration) * 3600 + Minute(DownloadTourMaster.FinalDuration) * 60+ Second(DownloadTourMaster.FinalDuration)
)
But its not working because FinalDuration column type id datetime in DownloadTourMaster table.
How i do this check ?
Please help me.
Thanks
Vikas
I want to check the null or empty value in report to datetime field .
This is my statement.
Switch(
Hour(DownloadTourMaster.FinalDuration) * 3600 + Minute(DownloadTourMaster.FinalDuration) * 60+ Second(DownloadTourMaster.FinalDuration)
)
I am checking like this.
Switch(
(int)Hour(DownloadTourMaster.FinalDuration) >0,
Hour(DownloadTourMaster.FinalDuration) * 3600 + Minute(DownloadTourMaster.FinalDuration) * 60+ Second(DownloadTourMaster.FinalDuration)
)
But its not working because FinalDuration column type id datetime in DownloadTourMaster table.
How i do this check ?
Please help me.
Thanks
Vikas