+ Start a Discussion
MMA_FORCEMMA_FORCE 

Formula???

Hi:

   What is wrong with this formula:

TODAY()+1 & '06:00:00' <== Tomorrow's Date at 6AM

It is a Date/Time Attribute...

 

Thanks

 

 

arunkarunk

Hi,

 

Can you copy paste the exact formula that you are using and are having trouble with.

Its very difficult to make out anything from what you have posted.

 

 

Regards,

Arun. 

KevinLaurenceKevinLaurence

Hi,

 

& concatenates two or more strings.

 

Today() + 1 does not produce a string, so your formula won't work.

 

 

fdsgkgreamfabofdsgkgreamfabo

Try to change the formula data type to string to mimic a date/time value.

e.g. text( today()) & " 06:00"

I may be wrong but i havn't see any function to create a date/time

Date and Datevalue generate Date data type only.