Date Conversion

Content Authoring
1

(imported topic written by jclark91)

I need to be able to evaluate a date stamp that is recorded in the registry as a string in the format: YYYYMMDD.

For example: 20070425

Is there a way to convert a string in this format to an actual date? I then need to evaluate the date to see if it is more than 30 days old.

Thanks for the help.

2

(imported comment written by jessewk)

how about this:

current date - date (( last 2 of it & " " & first 3 of (month (last 2 of first 6 of it as integer) as string) & " " & first 4 of it) of “20070425”) >= 30 * day