hi
i have a column which indicate as my date time data.
and i have two report parameter which work as start date and
End date.i want set my start date as minimum date in which stored in datetime column
and if no data stored be today date time
Thanks for wonderful suppor
i have a column which indicate as my date time data.
and i have two report parameter which work as start date and
End date.i want set my start date as minimum date in which stored in datetime column
and if no data stored be today date time
Thanks for wonderful suppor
1 Answer, 1 is accepted
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 07 Aug 2014, 03:42 PM
Hi British,
You can get the today's date/time by using the Now() built-in function.
For the minimum date/time you will need to write an appropriate SQL query and retrieve it.
You can get the today's date/time by using the Now() built-in function.
For the minimum date/time you will need to write an appropriate SQL query and retrieve it.