Forum Discussion
Key
I think you might be are out of luck there, M functions "update" when evaluated. If you need a "static" value that will have to be provided by a datasource. For example, the date/time a file or an export was created and so on.
Depending on your scenario and its complexity, you could generate a list or column of values (indices) from which you take the first "free" number...
- Hi m_dekorte thank you for your speedy reply. I have tried this but, unless I am doing something wrong each time I reference the separate query it comes back with an updated time. Any suggestions?
Resident RockstarHi TonyHollywood ,
You are right. Don't know why you want to include time in your key but maybe consider:
1. Lowering the granularity, how about stripping off seconds?
DateTime.ToText( DateTime.FixedLocalNow(), [Format= "dd-MM-yyyy hh:mm"])
2. Round time for exampl up to quarters:
DateTime.From( Number.RoundUp( Number.From(DateTime.FixedLocalNow()) * ((24*60)/15), 0)/ ((24*60)/15))
3. Or setting an arbitrary time value
I hope this is helpful
Thanks again m_dekorte, really appreciate your help. At least I know now I am not going mad.
I am using the datetime as I want to generate a key that is unlikely to be replicated. Any suggestions as to how I can generate something unique out a function that will remain 'static' ?
- m_dekorte
I think you might be are out of luck there, M functions "update" when evaluated. If you need a "static" value that will have to be provided by a datasource. For example, the date/time a file or an export was created and so on.
Depending on your scenario and its complexity, you could generate a list or column of values (indices) from which you take the first "free" number...
Many thanks for your help m_dekorte.