I would like to set up a script that pastes the first of the current month and beyond in a date field - 1/current month/current year...

I think I should use Paste calculated value but I can't seem to get the formula right

any help appreciated

thanks

Hi Robert,

Have you looked at the Insert Current Date [select,

would this not paste the current day as well as month & year?

Yes, then what do you want in the field then.

I would like it to paste this : 1 / current month / current date ...

In other words always find from the 1st of the current month

sorry I mean:

I would like it to paste this : 1 / current month / current year ...

In other words always find from the 1st of the current month

Try this and see if it is what you want

Insert Calculated Result [select,

That did the trick

thank you very much

To be more format friendly, Set Field [yourdate, Date( Month(Status(CurrentDate)), 1, Year(Status(CurrentDate)) )].