get data by date

get data by date

  

Hello


In the table I have Date column (datatype is datetime #2018-10-01 18:00:00#, #2018-10-01 14:30:40#) and in agregate I want to select all columns by date(#2018-10-01#). How can I do it? 

Solution

Hi Stepan,

In aggregate, use below code in filter

SyntaxEditor Code Snippet

DateTimeToDate(DairyEntry.Date) = DateTimeToDate(CurrDate())

Instead of currdate() use your date variable.

Thanks,

Rajat Agrawal

Solution

Hi Stepan,

You can convert your Date Column(which is actually DateTime) of DairyEntry to Date and then use condition as given below:

DateTimeToDate(DairyEntry.Date) = CurrDate()

Regards,

Himanshu

Thank you.... it helps :)

Welcome Stepan  :)