Forum Discussion
Data output
Hi everyone, Can anyone help me code, im trying to get my value from the last day of each month at 1130 PM. Im unsure how to code to find the last day of each month Thank you.
Anonymous , For new column, for any date you want to know last date of month
New column = eomonth([date], 0)
for today // you can use today in new column
New column = eomonth(today(), 0)
Hello sir,
I am trying to obtain the last day of the month that the data is in. For exmple on January, last day is 31 January. From the code, it gives the last day of the month before
Anonymous , For new column, for any date you want to know last date of month
New column = eomonth([date], 0)
for today // you can use today in new column
New column = eomonth(today(), 0)
works for me thankuu