I've got a simple spreadsheet that I want to import. The problem is that I've got a date column that I didn't format as a date. It's actually two columns of text data, one showing the day of week and one showing the day of the month. I've attached an image to illustrate.

The only solution I can think of is to import the data without those two columns and add an empty date field.

Then my query becomes: how do I enter a sequence of dates? Could I use Replace Field Contents with a series of numbers that could be then converted to dates? Or is there a way to do this with a calculation?

Hi,

As I can see - you have a sequence of days from date.

Question is - do you need to convert to dates once (after import) or calculate all the time?

If once, I'll use temporary script - starting from first record and looping through the end and new date field.

You can use LeftWords function to get next or current month.

And year is defined by script.

how do I enter a sequence of dates? Could I use Replace Field Contents

Yes, you can Replace Field Contents of your date field with a calculated result, e.g. =

Date ( 12 ; 28 ; 2009 ) + Get (RecordNumber)

One time only but, looking ahead, I think the next reply is my answer...

thanks

Yes, you can Replace Field Contents of your date field with a calculated result, e.g. =

Date ( 12 ; 28 ; 2009 ) + Get (RecordNumber)

Fantastic! Exactly what I was hoping for.

Thank you lots.