That did it, thank you. But yeah I am using EG as SQL while not completely foreign, I have not learned or been trained in my current role. Should probably work on that. Thank you again.
... View more
I'm trying to make a computed column with the lowest date so then I can run a select distinct query excluding the original column and result in one date per record.
... View more
Hi, I need to find the lowest value in a date column, but i'm not entirely sure how to go about it. Sample data attached. I'm new to this, but I tried using a min function, that didn't work. Tried creating a case to cover it, but that didn't either, any help is appreciated.
... View more
both of these solutions are very helpful and I appreciate, really the first one is all I needed to use in a between filter. thank you though will use it for the output
... View more
I'm trying to increment a date time that is formatted 19FEB2019:00:00:00.000, using the intnx function by 10 days, but Using this code: INTNX('dtday', t1.CLCL_RECD_DT,10) is returning 1867017600 and i'm not entirely sure what to do with that, is that 10 days after in seconds? Can I convert it?
... View more