I am trying to convert my date field (which is a 'string' datatype) in to a date field that is a date or number type so I can perform other operations. However, I have tried converting many different ways and am still having no success. My report basically shows the last activity of a customer and I am trying to write an if then statement that will pinpoint any customers that have not had any activity in the last 24 hours.
my date string is length 22 and looks like this :
yyyy/mm/dd hh:mm:ss.ss
all I really need to convert it to is a datefield with your basic date/time so I can then use the formula
datefield1 >= currentdate - 1
I know this is a mouthfull but any help available would be much appreciated.
- David
my date string is length 22 and looks like this :
yyyy/mm/dd hh:mm:ss.ss
all I really need to convert it to is a datefield with your basic date/time so I can then use the formula
datefield1 >= currentdate - 1
I know this is a mouthfull but any help available would be much appreciated.
- David