Fusion Manage Forum
Welcome to Autodesk’s Fusion Manage (formerly Fusion 360 Manage) Forum. Share your knowledge, ask questions, and explore popular Fusion Manage topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Computed Field Syntax

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
dkeeley
646 Views, 2 Replies

Computed Field Syntax

Hi,

 

I previosuly used SQLT on computed fields. This now longer appears to work. I believe the new syntax is PosdtgreSQL. Can you tell me how I can extract the week from a date in a computed field? Also how can I display today's date. I can displat the timestanp using 'now()' but I can't figure out how to extract just the date portion.

 

Thanks for you help,

 

David.

2 REPLIES 2
Message 2 of 3
Andrew.Shaw
in reply to: dkeeley

Hello David,

 

You can extract the day as a string by using the following formula: to_char(FIELD_NAME,'dd').

 

However, if the target data type is numerical, use the following formula: to_number(to_char(FIELD_NAME,'dd'),'99').

 

Best regards,



Andrew Shaw
Premium Support Specialist PLM/PDM
Global Services
Autodesk, Inc.

Message 3 of 3
dkeeley
in reply to: Andrew.Shaw

Thanks Andrew! Perfect.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report