todate function is returning date format in user

saravanarajanj

Certified Senior Developer

over 8 years ago

Hi,
I am using todate() function to convert a text to date value. The function does not take any parameters for dateformat.
the function always returns the date format based on user locale preference only. Is there any alternate approach that I can try, thanks in advance for the suggestions!

Discussion posts and replies are publicly visible

Parents

0 reginaldm377 over 8 years ago

Try this. 1st line (the 1st conversion) & the 2nd line (saving back into DB) converting that conversion into a date. Adjust code as needed and hope this helps.

with(
local!date:datetext(todate(now()), "DD-MM-YYYY"),
todate(local!date)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 reginaldm377 over 8 years ago

Try this. 1st line (the 1st conversion) & the 2nd line (saving back into DB) converting that conversion into a date. Adjust code as needed and hope this helps.

with(
local!date:datetext(todate(now()), "DD-MM-YYYY"),
todate(local!date)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data