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 ?
Please sign in to leave a comment.