Hi Good Folks, I'm Trying to see if Next Run date...
# suitescriptr
reza.seedin
04/02/2020, 12:55 AMHi Good Folks, I'm Trying to see if Next Run date time is in the Past. But get invalid expression. what Trick do I need to Or is there a better way to see if something is in the past
m
michoel
04/02/2020, 12:56 AMDid you try changing the formula type to numeric instead of date/time?
r
reza.seedin
04/02/2020, 12:56 AMmessage has been deleted
reza.seedin
04/02/2020, 12:56 AMOhhh will try number
reza.seedin
04/02/2020, 12:58 AMWell that does give me SOMETHING.. Might be able to use it as a condition which is what I wanted
reza.seedin
04/02/2020, 1:19 AMAny one can give me a hit how to add this into a FILTER to only show PAST ones. Currently getting a error when I add that filter as numeric
b
battk
04/02/2020, 2:14 AMthis does not sound like a task that requires a formula
r
reza.seedin
04/02/2020, 2:14 AMI'm open to Ideas 😄 Don't have much practice with formular TBH
reza.seedin
04/02/2020, 2:15 AMBasically want to see if Column Last run (date time) is in the past
b
battk
04/02/2020, 2:21 AMadd a filter for your Date/time field
battk
04/02/2020, 2:23 AMchoose the value named today from the input selector filter
battk
04/02/2020, 2:25 AMmessage has been deleted
r
reza.seedin
04/02/2020, 3:30 AMGiving it a try
reza.seedin
04/02/2020, 3:41 AMDidn't work cos I need to look at the time factor as well. I works if the Last run date is yesterday.. Current TIme is 2.40PM on the 2nd April, If I put last run as 1pm on the second nothing comes If i put yesterday then it work
reza.seedin
04/02/2020, 3:42 AMAlternatively I'm thinking of using moment to get the date and time
b
battk
04/02/2020, 4:03 AMyou can try relative filters
r
reza.seedin
04/02/2020, 4:16 AMSorry what do @battk mean by relative fields
b
battk
04/02/2020, 4:26 AMtype the word relative in the field where you selected today