Jump to content
Brogan6

Set date field script step yields ?

Recommended Posts

Brogan6

I have a script that pulls a variable that is a date that is properly formatted. I use the set field step to place the variable into a date field. The result is a question mark. The field is not a calculated field and the date is properly formatted. When I click on the date field in browse mode it still remains as a question mark. I can enter the date directly in the field exactly as the script step does and the date enters correctly. I have tried the script on multiple layouts and get the same results. I have also just tried to enter a date with the set script with the value entered as ”7/17/2018” and still get a question mark. The field is a simple date field with no additional formatting. Any ideas?

Share this post


Link to post
Share on other sites
Brogan6

I am not sure why Set Field will not work but I did find a solution. I used Insert Calculated result instead and it works fine.

Share this post


Link to post
Share on other sites
Steve Martino

You don't need the quotes for dates.

Share this post


Link to post
Share on other sites
Techphan

I use a calculation ---> Date(7;17;2018)

Share this post


Link to post
Share on other sites
AHunter3

Set Field [YourTable::YourField; GetAsDate ("7/17/2018")]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×