How to generate a sequence of dates for import?

[ebenjen]

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?

[Peter (duksis3)]

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.

[comment]

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)

[ebenjen]

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

thanks

[ebenjen]

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.