Advanced Filters
Hi...I am new to Datameer...just wondering about the functions that can be used in advanced filters for DATE fields ? I need to get all the rows that are there in the table for the past 24 hrs based on the Batch_Control_Dt. The date column is formatted within Datameer to support yyyy-MM-dd format.
I tried #sheetname!columnname >= NOW() - 30d ...it does not seem to work for the days either.
Pls explain TIMESTAMP(#sheetname!columnname) < TIMESTAMP(NOW()-20000)....what does this 20000 means ? Are they milliseconds ?
Where can I find the function explanations ?
-
Hello,
Function TIMESTAMP(<date>) - Difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC. Please fewer to Date and Time Functions to get more information of different time and date function available in Datameer.
Perhaps for mentioned case you could try the following filter: TIMESTAMP(#A) >= TIMESTAMP(#Batch_Control_Dt)-24h
Please sign in to leave a comment.
Comments
1 comment